Ejemplo n.º 1
0
class Migration(migrations.Migration):

    initial = True

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

    operations = [
        migrations.CreateModel(
            name="OIDCUserOfflineTokens",
            fields=[
                (
                    "id",
                    models.AutoField(
                        auto_created=True,
                        primary_key=True,
                        serialize=False,
                        verbose_name="ID",
                    ),
                ),
                ("user_id", models.CharField(max_length=50)),
                ("creation_date", models.DateTimeField(auto_now_add=True)),
                ("offline_token", models.BinaryField()),
            ],
            options={
                "db_table": "oidc_user_offline_tokens",
            },
        ),
        migrations.CreateModel(
            name="OIDCUser",
            fields=[],
            options={
                "proxy": True,
                "indexes": [],
                "constraints": [],
            },
            bases=("auth.user", ),
            managers=[
                ("objects", django.contrib.auth.models.UserManager()),
            ],
        ),
    ]
Ejemplo n.º 2
0
class Migration(migrations.Migration):

    initial = True

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

    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')),
                ('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')),
                ('extra_field', models.CharField(blank=True, max_length=120)),
                ('sex',
                 models.CharField(choices=[('male', 'male'),
                                           ('female', 'female'),
                                           ('other', 'other')],
                                  max_length=10)),
                ('is_remote_user', models.BooleanField(default=False)),
                ('phone_number',
                 models.CharField(
                     blank=True,
                     max_length=120,
                     validators=[
                         django.core.validators.RegexValidator(
                             message='Invalid phone number (e.g 237*********)',
                             regex='^(237)\\d{9}$')
                     ])),
                ('profil_picture',
                 models.ImageField(blank=True, null=True, upload_to='')),
                ('ville_residence',
                 models.CharField(default='Pas de ville choisie',
                                  max_length=100)),
                ('adresse',
                 models.CharField(default='Adresse non précisée',
                                  max_length=100)),
                ('groups',
                 models.ManyToManyField(
                     blank=True,
                     help_text=
                     'The groups this user belongs to. A user will get all permissions granted to each of their groups.',
                     related_name='user_set',
                     related_query_name='user',
                     to='auth.Group',
                     verbose_name='groups')),
                ('user_permissions',
                 models.ManyToManyField(
                     blank=True,
                     help_text='Specific permissions for this user.',
                     related_name='user_set',
                     related_query_name='user',
                     to='auth.Permission',
                     verbose_name='user permissions')),
            ],
            options={
                'verbose_name': 'user',
                'verbose_name_plural': 'users',
                'abstract': False,
            },
            managers=[
                ('objects', django.contrib.auth.models.UserManager()),
            ],
        ),
        migrations.CreateModel(
            name='ConfirmToken',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('kind',
                 models.CharField(choices=[('SIGNUP_TOKEN', 'SIGNUP_TOKEN'),
                                           ('PASSWORD_TOKEN',
                                            'PASSWORD_TOKEN'),
                                           ('EMAIL_TOKEN', 'EMAIL_TOKEN')],
                                  max_length=20)),
                ('token_hash', models.BinaryField(blank=True)),
                ('token_epires_at',
                 models.DateTimeField(default=datetime.datetime.now)),
                ('extra_data', models.TextField(blank=True, null=True)),
                ('user',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'unique_together': {('kind', 'user')},
            },
        ),
    ]
Ejemplo n.º 3
0
class Migration(migrations.Migration):

    initial = True

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

    operations = [
        migrations.CreateModel(
            name='Avatar',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('avatar', models.ImageField(upload_to='avatar/')),
                ('date_of_add', models.DateTimeField()),
            ],
        ),
        migrations.CreateModel(
            name='User',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('password', models.CharField(max_length=128, verbose_name='password')),
                ('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')),
                ('is_superuser', models.BooleanField(default=False, help_text='Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')),
                ('username', models.CharField(error_messages={'unique': 'A user with that username already exists.'}, help_text='Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, validators=[django.contrib.auth.validators.UnicodeUsernameValidator()], verbose_name='username')),
                ('first_name', models.CharField(blank=True, max_length=30, verbose_name='first name')),
                ('last_name', models.CharField(blank=True, max_length=150, verbose_name='last name')),
                ('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')),
                ('status', models.CharField(blank=True, default='', max_length=40)),
                ('surname', models.CharField(blank=True, default='', help_text='patronymic(optional)', max_length=40)),
                ('country', models.CharField(blank=True, default='', max_length=60)),
                ('city', models.CharField(blank=True, default='', max_length=60)),
                ('hobby', models.TextField(blank=True, default='', max_length=200)),
                ('sex', models.PositiveSmallIntegerField(choices=[(0, 'Not added'), (1, 'Male'), (2, 'Female')], default=0, null=True)),
                ('groups', models.ManyToManyField(blank=True, help_text='The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups')),
                ('user_permissions', models.ManyToManyField(blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions')),
            ],
            options={
                'verbose_name': 'user',
                'verbose_name_plural': 'users',
                'abstract': False,
            },
            managers=[
                ('objects', django.contrib.auth.models.UserManager()),
            ],
        ),
        migrations.CreateModel(
            name='Subscribe',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('on_black_list', models.BinaryField(choices=[(1, 'Using'), (0, "Doesn't use")], default=0)),
                ('user_on_whom_subscribe', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='user_on_whom_subscribe', to=settings.AUTH_USER_MODEL)),
                ('user_who_subscribe', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='user_who_subscribe', to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.CreateModel(
            name='Post',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=80, unique=True, verbose_name='Name of Post')),
                ('body', models.TextField(verbose_name='Text of Post')),
                ('rating', models.IntegerField(default=0)),
                ('date_of_add', models.DateTimeField(auto_now=True)),
                ('creator', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.CreateModel(
            name='PictureToPost',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('picture', models.ImageField(upload_to='picture/')),
                ('post', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='MainApp.Post')),
            ],
        ),
        migrations.CreateModel(
            name='Message',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('text', models.TextField(max_length=300)),
                ('receiver', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='message_receiver', to=settings.AUTH_USER_MODEL)),
                ('sender', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='message_sender', to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.CreateModel(
            name='AvatarUsed',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('avatar', models.OneToOneField(null=True, on_delete=django.db.models.deletion.SET_NULL, to='MainApp.Avatar')),
                ('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.AddField(
            model_name='avatar',
            name='user',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL),
        ),
    ]
class Migration(migrations.Migration):

    initial = True

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

    operations = [
        migrations.CreateModel(
            name='Owner',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('password',
                 models.CharField(max_length=128, verbose_name='password')),
                ('last_login',
                 models.DateTimeField(blank=True,
                                      null=True,
                                      verbose_name='last login')),
                ('is_superuser',
                 models.BooleanField(
                     default=False,
                     help_text=
                     'Designates that this user has all permissions without explicitly assigning them.',
                     verbose_name='superuser status')),
                ('username',
                 models.CharField(
                     error_messages={
                         'unique': 'A user with that username already exists.'
                     },
                     help_text=
                     'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.',
                     max_length=150,
                     unique=True,
                     validators=[
                         django.contrib.auth.validators.
                         UnicodeUsernameValidator()
                     ],
                     verbose_name='username')),
                ('first_name',
                 models.CharField(blank=True,
                                  max_length=30,
                                  verbose_name='first name')),
                ('last_name',
                 models.CharField(blank=True,
                                  max_length=150,
                                  verbose_name='last name')),
                ('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')),
                ('full_name',
                 models.CharField(help_text='Full name of the user',
                                  max_length=200)),
                ('phone',
                 models.CharField(
                     help_text=
                     'User phone number (no spaces or dashes, 10 character max)',
                     max_length=10)),
                ('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={
                'verbose_name': 'user',
                'verbose_name_plural': 'users',
                'abstract': False,
            },
            managers=[
                ('objects', django.contrib.auth.models.UserManager()),
            ],
        ),
        migrations.CreateModel(
            name='Event',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('timestamp',
                 models.DateTimeField(
                     auto_now=True, help_text='Time that the event happened')),
                ('duration',
                 models.IntegerField(
                     help_text='Number of seconds that the event occurred for')
                 ),
                ('event_type',
                 models.CharField(
                     help_text=
                     'String representing the type of event that occurred',
                     max_length=200)),
            ],
        ),
        migrations.CreateModel(
            name='Lock',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('address',
                 models.CharField(
                     default='N/A',
                     help_text='Address of the home where the lock is',
                     max_length=400)),
                ('ip_address',
                 models.CharField(
                     default='127.0.0.1',
                     help_text=
                     'IP Address of Raspberry Pi so we can connect to it.',
                     max_length=14)),
                ('lock_owner',
                 models.ForeignKey(help_text='User ID who owns the lock',
                                   on_delete=django.db.models.deletion.CASCADE,
                                   to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.CreateModel(
            name='Permission',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('allowed_access_general',
                 models.BooleanField(
                     default=False,
                     help_text='Is the user allowed to open the lock?')),
                ('time_start',
                 models.TimeField(
                     help_text=
                     'At what time can the user open the lock every day?')),
                ('time_end',
                 models.TimeField(
                     help_text='Until what time can the user open the lock?')),
                ('lock',
                 models.ForeignKey(
                     help_text='Lock that the permissions act on',
                     on_delete=django.db.models.deletion.CASCADE,
                     to='lock_owners.Lock')),
            ],
        ),
        migrations.CreateModel(
            name='Resident',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('full_name',
                 models.CharField(help_text='Full name of the resident',
                                  max_length=200)),
                ('lock',
                 models.ForeignKey(
                     help_text='The lock that this Resident was created for',
                     on_delete=django.db.models.deletion.CASCADE,
                     to='lock_owners.Lock')),
            ],
        ),
        migrations.CreateModel(
            name='ResidentImage',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('image_bytes',
                 models.BinaryField(editable=True,
                                    help_text='Image in bytes')),
                ('resident',
                 models.ForeignKey(
                     help_text='Resident that this is an image of',
                     on_delete=django.db.models.deletion.CASCADE,
                     to='lock_owners.Resident')),
            ],
        ),
        migrations.CreateModel(
            name='StrangerReport',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('latitude',
                 models.FloatField(
                     help_text='latitude of suspicious reporting')),
                ('longitude',
                 models.FloatField(
                     help_text='longitude of suspicious reporting')),
                ('stranger_report_time',
                 models.DateTimeField(
                     default=datetime.datetime(2019, 4, 21, 10, 46, 16,
                                               560230),
                     help_text='Date and time the report was made')),
                ('lock',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to='lock_owners.Lock')),
            ],
        ),
        migrations.CreateModel(
            name='TempAuth',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('visitor',
                 models.CharField(help_text='Identifying name for the visitor',
                                  max_length=200)),
                ('time_created',
                 models.DateTimeField(
                     auto_now=True,
                     help_text=
                     'Time that the temporary authentication code was assigned'
                 )),
                ('auth_code',
                 models.CharField(
                     default='4e1e68a3-c353-4dea-a26b-fe885c84db32',
                     editable=False,
                     help_text=
                     'The temporary authentication code to assign to the user',
                     max_length=200)),
                ('lock',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to='lock_owners.Lock')),
            ],
        ),
        migrations.AddField(
            model_name='permission',
            name='resident',
            field=models.ForeignKey(
                help_text='User that permissions are for',
                on_delete=django.db.models.deletion.CASCADE,
                to='lock_owners.Resident'),
        ),
        migrations.AddField(
            model_name='event',
            name='lock',
            field=models.ForeignKey(
                help_text='Lock where the event occurred',
                on_delete=django.db.models.deletion.CASCADE,
                to='lock_owners.Lock'),
        ),
        migrations.AddField(
            model_name='owner',
            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'),
        ),
    ]
Ejemplo n.º 5
0
class Migration(migrations.Migration):

    initial = True

    dependencies = [
        ('auth', '0009_alter_user_last_name_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')),
                ('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')),
                ('private_key', models.BinaryField(blank=True, default=b'-----BEGIN RSA PRIVATE KEY-----\nMIIEpAIBAAKCAQEAr9nT3fPg5xWyF9w+X+Pc2junbhuzppPsNEEj2zTOIXJsU6ar\nbFuZgpZYRh9UIwq8ee0PMPf+QoxQaFyG/A3Idkt6AtIK6/Eoc4Eqjl91fhKApzp4\nMXygWdSTr6hAGRKprSH99dh1faRghdqKo9ngk687GGzH4StqZdjHOGEGQ6CHcPjX\nFakoQoNz+6fNZ2jDwiH2Xz+c4faaX954RbKdBf6X/Rm10i6WNKSF7rusYtSkfeag\nOc6I/8CEghSQ+7AcESDmccMcQVX88RGCQBrvwhQtDBszOqYA7SwKiKwbIMl8BDic\nhJSSWMl70Axw92qHPL7DHFQpP7h1jjtW9Aoe9QIDAQABAoIBAQCC3HT/3LbnAIwx\nmWKJdUYq2O210MOWGMpT8I3AWMF0vnPCpGs5DcllFoDGXhX8pcawbSs647HA0C4e\nG40QESm2bmBzrN8XybSyj9KddIg4s4gt6iL7oKSrdLgapfhdMDg4cO1OgDCeuS5j\nLciyOjcXb/VoLbto4yggdnt6hylkNNrsCta3TvXGZXAP+MGxa/utDQ4E36ut9bcb\nIy/Py42RJP1ctgUuzuiJUKf+ys+lNejhRD+2OS6a3ADufZtZgXbPPNl7OZC+spUz\nEnl6u0ku5GtnfCH0TpM6vv2cIrMmzGPjjUj6ybqAEcLmiI31LzeGKLa7PNO3gp+p\nLehLYCIBAoGBAObb3Ef8IWumkE1pjnPfrC/im0HktQDFnF8YHgCgOOFbfFaBtvSG\nbzVoY7LZxMZ239ajxpLelsu5oj+DHeBQPQG/AByoGkBG9Fe65BddO6uuXgD6uzHM\nlHr4GtJLVEjfPDj8jIo1giBrz2y8fAA+KNyNSuJsnDJHIzSn/eZE2Q1BAoGBAMMA\nZP4ztu5lMe2GuaDdbNO9NswRki0X96W3ttXiU6YT9fxk/whdX6iQEinU9nyE4v+j\nnMF+UbfbSOdu0dpCCvgNAmRaaiHicu0QQmlArjfwqPa6Ct4fO/hcQOPxdcQeF1Ig\nc87+YPRo2tes8lWAx7x7seru1iG32VbMvfO848C1AoGBAOJwIN7SpY1LsRrdQIbT\ni7bkVFkLlaaOLdTweO0wOtqAu7K2RNgPzKDcJX5WL7Zi/ycvOSTyA4MML+KQHwvY\naB6AVAHHuQf3EM/EVtm77z10KGxZgqdT/Qeot9YxYRihLhbPUKJ33Y0jci87qX0r\nezTpudvhoEuIjzWk2Vu1iBiBAoGACKlY0w26/2XRTOqiDionrlQGPhQ9uPEKl/rM\nDT4LVyIl1/sodNeo6xTTKbaC6E8CwjYjPVj+CjucRmNewOIUGKaDR6/YbP7g+fSx\n7njoBCYVazgiSXF7uXFnlHhiMb7gbE5ytmwIJHMP3WqaLQAWXyHjajsHmeHPrpJT\nkaL/Ps0CgYBxjfr3Kv0m6jdJP3W7K6nwTaZjN+MxhEalelxk6Bx6Kua7bCQuiPOJ\nejKQiSy5CfT2/g8mkB5m+B6u4jsdjpSRm8kyVJ0EVHRhok1AJC+E5i1D/dsxBpzU\nly/EtQWotHg9XqNJF83lUtN7BuROWan6N4v7mT7gDuefSAQqDo4Wcw==\n-----END RSA PRIVATE KEY-----\n', unique=True)),
            ],
            options={
                'verbose_name': 'user',
                'verbose_name_plural': 'users',
                'abstract': False,
            },
            managers=[
                ('objects', django.contrib.auth.models.UserManager()),
            ],
        ),
        migrations.CreateModel(
            name='Message',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('text', models.CharField(blank=True, max_length=300, null=True)),
                ('contain', models.BinaryField(blank=True, null=True)),
                ('was_verify', models.BooleanField(default=False)),
                ('is_correct', models.BooleanField(default=False)),
            ],
        ),
        migrations.CreateModel(
            name='Permission',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
            ],
        ),
        migrations.CreateModel(
            name='Key',
            fields=[
                ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to=settings.AUTH_USER_MODEL)),
                ('public_key', models.BinaryField(unique=True)),
            ],
        ),
        migrations.AddField(
            model_name='permission',
            name='user',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL),
        ),
        migrations.AddField(
            model_name='message',
            name='user_from',
            field=models.ForeignKey(on_delete=django.db.models.deletion.DO_NOTHING, related_name='sender', to=settings.AUTH_USER_MODEL),
        ),
        migrations.AddField(
            model_name='message',
            name='user_to',
            field=models.ForeignKey(on_delete=django.db.models.deletion.DO_NOTHING, related_name='reciver', to=settings.AUTH_USER_MODEL),
        ),
        migrations.AddField(
            model_name='customuser',
            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='customuser',
            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='permission',
            name='user_key',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='users.Key'),
        ),
    ]
class Migration(migrations.Migration):

    initial = True

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

    operations = [
        migrations.CreateModel(
            name='UserRegistration',
            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=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')),
                ('username', models.CharField(max_length=30)),
                ('full_name', models.CharField(max_length=50)),
                ('user_country', models.BigIntegerField()),
                ('user_mail', models.CharField(max_length=100, unique=True)),
                ('user_phoneno', models.CharField(max_length=15, unique=True)),
                ('usertype', models.BigIntegerField()),
                ('user_location', models.TextField()),
                ('company_name', models.CharField(max_length=20)),
                ('user_otp', models.CharField(max_length=6, null=True)),
                ('groups', models.ManyToManyField(blank=True, help_text='The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups')),
                ('user_permissions', models.ManyToManyField(blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions')),
            ],
            options={
                'db_table': 'UserRegistration',
            },
            managers=[
                ('objects', django.contrib.auth.models.UserManager()),
            ],
        ),
        migrations.CreateModel(
            name='BankDetails',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('acc_holder_name', models.CharField(max_length=30)),
                ('type_account', models.CharField(max_length=30)),
                ('bank_name', models.CharField(max_length=30)),
                ('account_no', models.CharField(max_length=20)),
                ('ifsc_code', models.CharField(max_length=25)),
                ('branch', models.CharField(max_length=20)),
                ('transfer_type', models.CharField(max_length=20)),
                ('swift_code', models.CharField(max_length=25)),
                ('micr_no', models.CharField(max_length=25)),
                ('iban_code', models.CharField(max_length=25)),
                ('created_by_id', models.BigIntegerField()),
                ('created_on', models.DateTimeField(auto_now_add=True)),
                ('updated_on', models.DateTimeField(auto_now=True)),
                ('updated_by_id', models.BigIntegerField()),
            ],
            options={
                'db_table': 'BankDetails',
            },
        ),
        migrations.CreateModel(
            name='CommunicationDetailsCompanyAddress',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('company_name', models.CharField(max_length=50)),
                ('country', models.BigIntegerField()),
                ('state', models.BigIntegerField()),
                ('city', models.BigIntegerField()),
                ('pincode', models.CharField(max_length=10)),
                ('landmark', models.CharField(max_length=50)),
                ('address', models.CharField(max_length=100)),
                ('website', models.CharField(max_length=20)),
                ('mail_id', models.CharField(max_length=50)),
                ('telephone', models.CharField(max_length=15)),
                ('mobile', models.CharField(max_length=15)),
            ],
            options={
                'db_table': 'CommunicationDetailsCompanyAddress',
            },
        ),
        migrations.CreateModel(
            name='CommunicationDetailsShippingAddress',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('shipping_company_name', models.CharField(max_length=50)),
                ('shipping_country', models.BigIntegerField()),
                ('shipping_state', models.BigIntegerField()),
                ('shipping_city', models.BigIntegerField()),
                ('shipping_pincode', models.CharField(max_length=10)),
                ('shipping_landmark', models.CharField(max_length=50)),
                ('shipping_address', models.CharField(max_length=100)),
                ('shipping_mail_id', models.CharField(max_length=50)),
                ('shipping_telephone', models.CharField(max_length=15)),
                ('shipping_mobile', models.CharField(max_length=15)),
            ],
            options={
                'db_table': 'CommunicationDetailsShippingAddress',
            },
        ),
        migrations.CreateModel(
            name='ContactDetails',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=20)),
                ('dept', models.BigIntegerField()),
                ('designation', models.BigIntegerField()),
                ('contact_no', models.CharField(max_length=15)),
                ('mobile_no', models.CharField(max_length=15)),
                ('mail_id', models.CharField(max_length=30)),
            ],
            options={
                'db_table': 'Contact_Details',
            },
        ),
        migrations.CreateModel(
            name='LegalInformation',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('document_name', models.CharField(max_length=20)),
                ('registered_date', models.DateField()),
                ('valid_till', models.DateField()),
                ('upload_document', models.FileField(upload_to='')),
                ('document', models.BinaryField(null=True)),
                ('user_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'db_table': 'LegalInformation',
            },
        ),
        migrations.CreateModel(
            name='BasiCompanyInfo',
            fields=[
                ('basic_company_info_id', models.BigAutoField(primary_key=True, serialize=False)),
                ('company_code', models.CharField(max_length=100)),
                ('company_name', models.CharField(max_length=100)),
                ('company_type', models.BigIntegerField()),
                ('tax_payer_type', models.BigIntegerField()),
                ('registration_date', models.DateTimeField()),
                ('buziness_country', models.BigIntegerField()),
                ('buziness_currency', models.BigIntegerField()),
                ('buziness_type', models.CharField(max_length=20)),
                ('msme_registered', models.BooleanField()),
                ('gst_no', models.CharField(max_length=20)),
                ('pan_no', models.CharField(max_length=10)),
                ('nature_of_buziness', models.BigIntegerField()),
                ('created_by_id', models.BigIntegerField()),
                ('created_on', models.DateTimeField(auto_now_add=True)),
                ('updated_on', models.DateTimeField(auto_now=True)),
                ('updated_by_id', models.BigIntegerField()),
                ('user_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'db_table': 'BasiCompanyInfo',
            },
        ),
    ]
Ejemplo n.º 7
0
class Migration(migrations.Migration):

    initial = True

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

    operations = [
        migrations.CreateModel(
            name='MyUser',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('password',
                 models.CharField(max_length=128, verbose_name='password')),
                ('last_login',
                 models.DateTimeField(blank=True,
                                      null=True,
                                      verbose_name='last login')),
                ('is_superuser',
                 models.BooleanField(
                     default=False,
                     help_text=
                     'Designates that this user has all permissions without explicitly assigning them.',
                     verbose_name='superuser status')),
                ('username',
                 models.CharField(
                     error_messages={
                         'unique': 'A user with that username already exists.'
                     },
                     help_text=
                     'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.',
                     max_length=150,
                     unique=True,
                     validators=[
                         django.contrib.auth.validators.
                         UnicodeUsernameValidator()
                     ],
                     verbose_name='username')),
                ('first_name',
                 models.CharField(blank=True,
                                  max_length=30,
                                  verbose_name='first name')),
                ('last_name',
                 models.CharField(blank=True,
                                  max_length=150,
                                  verbose_name='last name')),
                ('is_staff',
                 models.BooleanField(
                     default=False,
                     help_text=
                     'Designates whether the user can log into this admin site.',
                     verbose_name='staff status')),
                ('is_active',
                 models.BooleanField(
                     default=True,
                     help_text=
                     'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.',
                     verbose_name='active')),
                ('date_joined',
                 models.DateTimeField(default=django.utils.timezone.now,
                                      verbose_name='date joined')),
                ('email', models.EmailField(max_length=254, unique=True)),
                ('groups',
                 models.ManyToManyField(
                     blank=True,
                     help_text=
                     'The groups this user belongs to. A user will get all permissions granted to each of their groups.',
                     related_name='user_set',
                     related_query_name='user',
                     to='auth.Group',
                     verbose_name='groups')),
                ('user_permissions',
                 models.ManyToManyField(
                     blank=True,
                     help_text='Specific permissions for this user.',
                     related_name='user_set',
                     related_query_name='user',
                     to='auth.Permission',
                     verbose_name='user permissions')),
            ],
            options={
                'verbose_name': 'user',
                'verbose_name_plural': 'users',
                'abstract': False,
            },
            managers=[
                ('objects', django.contrib.auth.models.UserManager()),
            ],
        ),
        migrations.CreateModel(
            name='Sponsor',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('name', models.CharField(max_length=50)),
                ('logo', models.BinaryField()),
            ],
        ),
        migrations.CreateModel(
            name='Sponsorship',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('sponsor_id',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to='tournaments.Sponsor')),
            ],
        ),
        migrations.CreateModel(
            name='Tournament',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('name', models.CharField(max_length=50)),
                ('sport', models.CharField(max_length=50)),
                ('start_date', models.DateTimeField()),
                ('max_number_of_participants', models.IntegerField()),
                ('registration_deadline', models.DateTimeField()),
                ('country', models.CharField(max_length=50)),
                ('city', models.CharField(max_length=50)),
                ('street', models.CharField(max_length=50)),
                ('house_number', models.IntegerField()),
                ('host_id',
                 models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
                                   to=settings.AUTH_USER_MODEL)),
                ('sponsors',
                 models.ManyToManyField(through='tournaments.Sponsorship',
                                        to='tournaments.Sponsor')),
            ],
        ),
        migrations.AddField(
            model_name='sponsorship',
            name='tournament_id',
            field=models.ForeignKey(
                on_delete=django.db.models.deletion.CASCADE,
                to='tournaments.Tournament'),
        ),
        migrations.CreateModel(
            name='Participation',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('ranking', models.IntegerField()),
                ('license_number', models.CharField(max_length=50)),
                ('tournament_id',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to='tournaments.Tournament')),
                ('user_id',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.CreateModel(
            name='Match',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('winner_id', models.IntegerField(blank=True)),
                ('player1_id',
                 models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
                                   related_name='player 1+',
                                   to=settings.AUTH_USER_MODEL)),
                ('player2_id',
                 models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
                                   related_name='player 2+',
                                   to=settings.AUTH_USER_MODEL)),
                ('tournament_id',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to='tournaments.Tournament')),
            ],
        ),
    ]
Ejemplo n.º 8
0
class Migration(migrations.Migration):

    initial = True

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

    operations = [
        migrations.CreateModel(
            name='BaseFindingGroup',
            fields=[
                ('id',
                 models.UUIDField(default=uuid.uuid4,
                                  editable=False,
                                  primary_key=True,
                                  serialize=False)),
                ('name',
                 models.CharField(blank=True,
                                  default=str,
                                  max_length=1000,
                                  validators=[writehat.validation.isValidName
                                              ])),
                ('createdDate', models.DateTimeField(auto_now_add=True)),
                ('modifiedDate', models.DateTimeField(auto_now=True)),
                ('engagementParent', models.UUIDField(editable=False,
                                                      null=True)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='Customer',
            fields=[
                ('id',
                 models.UUIDField(default=uuid.uuid4,
                                  editable=False,
                                  primary_key=True,
                                  serialize=False)),
                ('createdDate', models.DateTimeField(auto_now_add=True)),
                ('modifiedDate', models.DateTimeField(auto_now=True)),
                ('name',
                 models.CharField(blank=True,
                                  max_length=1000,
                                  null=True,
                                  verbose_name='Company Name')),
                ('shortName',
                 models.CharField(blank=True,
                                  max_length=1000,
                                  null=True,
                                  verbose_name='Company Short Name')),
                ('domain',
                 models.CharField(blank=True,
                                  max_length=100,
                                  null=True,
                                  verbose_name='Internal Domain')),
                ('website',
                 models.CharField(blank=True,
                                  max_length=100,
                                  null=True,
                                  verbose_name='Primary Website')),
                ('address',
                 models.CharField(blank=True,
                                  max_length=1000,
                                  null=True,
                                  verbose_name='Company Address')),
                ('POC',
                 models.CharField(blank=True,
                                  max_length=1000,
                                  null=True,
                                  verbose_name='Company Point of Contact')),
                ('email',
                 models.EmailField(blank=True,
                                   max_length=254,
                                   verbose_name='Contact Email Address')),
                ('phone',
                 models.CharField(blank=True,
                                  max_length=100,
                                  null=True,
                                  verbose_name='Contact Phone Number')),
                ('parentResource', models.UUIDField(editable=False,
                                                    null=True)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='CVSSDatabaseFinding',
            fields=[
                ('id',
                 models.UUIDField(default=uuid.uuid4,
                                  editable=False,
                                  primary_key=True,
                                  serialize=False)),
                ('name',
                 models.CharField(blank=True,
                                  default=str,
                                  max_length=1000,
                                  validators=[writehat.validation.isValidName
                                              ])),
                ('createdDate', models.DateTimeField(auto_now_add=True)),
                ('modifiedDate', models.DateTimeField(auto_now=True)),
                ('categoryID', models.UUIDField(editable=False, null=True)),
                ('isApproved',
                 models.BooleanField(blank=True, default=False, null=True)),
                ('background',
                 writehat.models.MarkdownField(blank=True,
                                               max_length=30000,
                                               null=True)),
                ('remediation',
                 writehat.models.MarkdownField(blank=True,
                                               max_length=30000,
                                               null=True)),
                ('references',
                 writehat.models.MarkdownField(blank=True,
                                               max_length=30000,
                                               null=True)),
                ('scoringType',
                 models.CharField(default='CVSS',
                                  editable=False,
                                  max_length=50)),
                ('toolsUsed',
                 writehat.models.MarkdownField(blank=True,
                                               max_length=30000,
                                               null=True)),
                ('vector',
                 models.CharField(blank=True, max_length=150, null=True)),
            ],
            options={
                'abstract': False,
            },
            bases=(writehat.lib.finding.DatabaseOnlyFinding, models.Model),
        ),
        migrations.CreateModel(
            name='CVSSEngagementFinding',
            fields=[
                ('id',
                 models.UUIDField(default=uuid.uuid4,
                                  editable=False,
                                  primary_key=True,
                                  serialize=False)),
                ('name',
                 models.CharField(blank=True,
                                  default=str,
                                  max_length=1000,
                                  validators=[writehat.validation.isValidName
                                              ])),
                ('createdDate', models.DateTimeField(auto_now_add=True)),
                ('modifiedDate', models.DateTimeField(auto_now=True)),
                ('categoryID', models.UUIDField(editable=False, null=True)),
                ('isApproved',
                 models.BooleanField(blank=True, default=False, null=True)),
                ('background',
                 writehat.models.MarkdownField(blank=True,
                                               max_length=30000,
                                               null=True)),
                ('remediation',
                 writehat.models.MarkdownField(blank=True,
                                               max_length=30000,
                                               null=True)),
                ('references',
                 writehat.models.MarkdownField(blank=True,
                                               max_length=30000,
                                               null=True)),
                ('scoringType',
                 models.CharField(default='CVSS',
                                  editable=False,
                                  max_length=50)),
                ('toolsUsed',
                 writehat.models.MarkdownField(blank=True,
                                               max_length=30000,
                                               null=True)),
                ('vector',
                 models.CharField(blank=True, max_length=150, null=True)),
                ('findingGroup', models.UUIDField(editable=False, null=True)),
                ('description',
                 writehat.models.MarkdownField(blank=True,
                                               max_length=30000,
                                               null=True)),
                ('affectedResources',
                 writehat.models.MarkdownField(blank=True,
                                               max_length=30000,
                                               null=True)),
                ('proofOfConcept',
                 writehat.models.MarkdownField(blank=True,
                                               max_length=30000,
                                               null=True)),
            ],
            options={
                'abstract': False,
            },
            bases=(writehat.lib.engagementFinding.EngagementFinding,
                   models.Model),
        ),
        migrations.CreateModel(
            name='DatabaseFindingCategory',
            fields=[
                ('id',
                 models.UUIDField(default=uuid.uuid4,
                                  editable=False,
                                  primary_key=True,
                                  serialize=False)),
                ('name',
                 models.CharField(blank=True,
                                  default=str,
                                  max_length=1000,
                                  validators=[writehat.validation.isValidName
                                              ])),
                ('createdDate', models.DateTimeField(auto_now_add=True)),
                ('modifiedDate', models.DateTimeField(auto_now=True)),
                ('categoryParent', models.UUIDField(editable=False,
                                                    null=True)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='DREADFinding',
            fields=[
                ('id',
                 models.UUIDField(default=uuid.uuid4,
                                  editable=False,
                                  primary_key=True,
                                  serialize=False)),
                ('name',
                 models.CharField(blank=True,
                                  default=str,
                                  max_length=1000,
                                  validators=[writehat.validation.isValidName
                                              ])),
                ('createdDate', models.DateTimeField(auto_now_add=True)),
                ('modifiedDate', models.DateTimeField(auto_now=True)),
                ('categoryID', models.UUIDField(editable=False, null=True)),
                ('isApproved',
                 models.BooleanField(blank=True, default=False, null=True)),
                ('background',
                 writehat.models.MarkdownField(blank=True,
                                               max_length=30000,
                                               null=True)),
                ('remediation',
                 writehat.models.MarkdownField(blank=True,
                                               max_length=30000,
                                               null=True)),
                ('references',
                 writehat.models.MarkdownField(blank=True,
                                               max_length=30000,
                                               null=True)),
                ('scoringType',
                 models.CharField(default='DREAD',
                                  editable=False,
                                  max_length=50)),
                ('vector',
                 models.CharField(blank=True, max_length=150, null=True)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='Engagement',
            fields=[
                ('id',
                 models.UUIDField(default=uuid.uuid4,
                                  editable=False,
                                  primary_key=True,
                                  serialize=False)),
                ('name',
                 models.CharField(blank=True,
                                  default=str,
                                  max_length=1000,
                                  validators=[writehat.validation.isValidName
                                              ])),
                ('createdDate', models.DateTimeField(auto_now_add=True)),
                ('modifiedDate', models.DateTimeField(auto_now=True)),
                ('companyName',
                 models.CharField(blank=True,
                                  max_length=1000,
                                  null=True,
                                  verbose_name='Company Name')),
                ('companyShortName',
                 models.CharField(blank=True,
                                  max_length=1000,
                                  null=True,
                                  verbose_name='Company Short Name')),
                ('companyAddress',
                 models.CharField(blank=True,
                                  max_length=1000,
                                  null=True,
                                  verbose_name='Company Address')),
                ('companyPOC',
                 models.CharField(blank=True,
                                  max_length=1000,
                                  null=True,
                                  verbose_name='Company Point of Contact')),
                ('companyEmail',
                 models.EmailField(blank=True,
                                   max_length=254,
                                   verbose_name='Contact Email Address')),
                ('companyPhone',
                 models.CharField(blank=True,
                                  max_length=100,
                                  null=True,
                                  verbose_name='Contact Phone Number')),
                ('customerID',
                 models.UUIDField(blank=True,
                                  null=True,
                                  verbose_name='Customer')),
                ('pageTemplateID',
                 models.UUIDField(blank=True,
                                  null=True,
                                  verbose_name='Page Template')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='ImageModel',
            fields=[
                ('id',
                 models.UUIDField(default=uuid.uuid4,
                                  editable=False,
                                  primary_key=True,
                                  serialize=False)),
                ('name',
                 models.CharField(blank=True,
                                  default=str,
                                  max_length=1000,
                                  validators=[writehat.validation.isValidName
                                              ])),
                ('createdDate', models.DateTimeField(auto_now_add=True)),
                ('modifiedDate', models.DateTimeField(auto_now=True)),
                ('data', models.BinaryField(blank=True, null=True)),
                ('caption',
                 models.CharField(blank=True,
                                  default=str,
                                  max_length=1000,
                                  null=True,
                                  validators=[writehat.validation.isValidName
                                              ])),
                ('size', models.IntegerField(null=True)),
                ('findingParent',
                 models.UUIDField(blank=True, editable=False, null=True)),
                ('contentType',
                 models.CharField(blank=True, max_length=20, null=True)),
                ('order', models.IntegerField(blank=True, null=True)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='PageTemplate',
            fields=[
                ('id',
                 models.UUIDField(default=uuid.uuid4,
                                  editable=False,
                                  primary_key=True,
                                  serialize=False)),
                ('name',
                 models.CharField(blank=True,
                                  default=str,
                                  max_length=1000,
                                  validators=[writehat.validation.isValidName
                                              ])),
                ('createdDate', models.DateTimeField(auto_now_add=True)),
                ('modifiedDate', models.DateTimeField(auto_now=True)),
                ('parentResource', models.UUIDField(editable=False,
                                                    null=True)),
                ('background', models.UUIDField(editable=False, null=True)),
                ('logo', models.UUIDField(editable=False, null=True)),
                ('footer',
                 writehat.models.MarkdownField(blank=True,
                                               max_length=30000,
                                               null=True)),
                ('default',
                 models.BooleanField(blank=True, default=False, null=True)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='ProactiveFinding',
            fields=[
                ('id',
                 models.UUIDField(default=uuid.uuid4,
                                  editable=False,
                                  primary_key=True,
                                  serialize=False)),
                ('name',
                 models.CharField(blank=True,
                                  default=str,
                                  max_length=1000,
                                  validators=[writehat.validation.isValidName
                                              ])),
                ('createdDate', models.DateTimeField(auto_now_add=True)),
                ('modifiedDate', models.DateTimeField(auto_now=True)),
                ('categoryID', models.UUIDField(editable=False, null=True)),
                ('isApproved',
                 models.BooleanField(blank=True, default=False, null=True)),
                ('background',
                 writehat.models.MarkdownField(blank=True,
                                               max_length=30000,
                                               null=True)),
                ('remediation',
                 writehat.models.MarkdownField(blank=True,
                                               max_length=30000,
                                               null=True)),
                ('references',
                 writehat.models.MarkdownField(blank=True,
                                               max_length=30000,
                                               null=True)),
                ('scoringType',
                 models.CharField(default='PROACTIVE',
                                  editable=False,
                                  max_length=50)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='Report',
            fields=[
                ('id',
                 models.UUIDField(default=uuid.uuid4,
                                  editable=False,
                                  primary_key=True,
                                  serialize=False)),
                ('name',
                 models.CharField(blank=True,
                                  default=str,
                                  max_length=1000,
                                  validators=[writehat.validation.isValidName
                                              ])),
                ('createdDate', models.DateTimeField(auto_now_add=True)),
                ('modifiedDate', models.DateTimeField(auto_now=True)),
                ('_components',
                 models.TextField(
                     blank=True,
                     default=str,
                     validators=[writehat.validation.isValidComponentJSON])),
                ('pageTemplateID', models.UUIDField(blank=True, null=True)),
                ('engagementParent', models.UUIDField(editable=False,
                                                      null=True)),
                ('_findings',
                 models.TextField(blank=True,
                                  default=str,
                                  validators=[writehat.validation.isValidJSON
                                              ])),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='Revision',
            fields=[
                ('id',
                 models.UUIDField(default=uuid.uuid4,
                                  editable=False,
                                  primary_key=True,
                                  serialize=False)),
                ('name',
                 models.CharField(blank=True,
                                  default=str,
                                  max_length=1000,
                                  validators=[writehat.validation.isValidName
                                              ])),
                ('createdDate', models.DateTimeField(auto_now_add=True)),
                ('modifiedDate', models.DateTimeField(auto_now=True)),
                ('parentId', models.UUIDField()),
                ('fieldName', models.CharField(max_length=50)),
                ('fieldText', models.TextField(max_length=30000)),
                ('version', models.IntegerField()),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='SavedReport',
            fields=[
                ('id',
                 models.UUIDField(default=uuid.uuid4,
                                  editable=False,
                                  primary_key=True,
                                  serialize=False)),
                ('name',
                 models.CharField(blank=True,
                                  default=str,
                                  max_length=1000,
                                  validators=[writehat.validation.isValidName
                                              ])),
                ('createdDate', models.DateTimeField(auto_now_add=True)),
                ('modifiedDate', models.DateTimeField(auto_now=True)),
                ('_components',
                 models.TextField(
                     blank=True,
                     default=str,
                     validators=[writehat.validation.isValidComponentJSON])),
                ('pageTemplateID', models.UUIDField(blank=True, null=True)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='AssigneeUser',
            fields=[],
            options={
                'proxy': True,
                'indexes': [],
                'constraints': [],
            },
            bases=('auth.user', ),
            managers=[
                ('objects', django.contrib.auth.models.UserManager()),
            ],
        ),
        migrations.CreateModel(
            name='CVSSFindingGroup',
            fields=[
                ('basefindinggroup_ptr',
                 models.OneToOneField(
                     auto_created=True,
                     on_delete=django.db.models.deletion.CASCADE,
                     parent_link=True,
                     primary_key=True,
                     serialize=False,
                     to='writehat.basefindinggroup')),
                ('scoringType',
                 models.CharField(default='CVSS',
                                  editable=False,
                                  max_length=50)),
                ('prefix',
                 models.CharField(default='T',
                                  max_length=50,
                                  verbose_name='Finding Prefix')),
            ],
            options={
                'abstract': False,
            },
            bases=('writehat.basefindinggroup', ),
        ),
        migrations.CreateModel(
            name='DREADDatabaseFinding',
            fields=[
                ('dreadfinding_ptr',
                 models.OneToOneField(
                     auto_created=True,
                     on_delete=django.db.models.deletion.CASCADE,
                     parent_link=True,
                     primary_key=True,
                     serialize=False,
                     to='writehat.dreadfinding')),
            ],
            options={
                'abstract': False,
            },
            bases=(writehat.lib.finding.DatabaseOnlyFinding,
                   'writehat.dreadfinding'),
        ),
        migrations.CreateModel(
            name='DREADEngagementFinding',
            fields=[
                ('dreadfinding_ptr',
                 models.OneToOneField(
                     auto_created=True,
                     on_delete=django.db.models.deletion.CASCADE,
                     parent_link=True,
                     primary_key=True,
                     serialize=False,
                     to='writehat.dreadfinding')),
                ('findingGroup', models.UUIDField(editable=False, null=True)),
                ('description',
                 writehat.models.MarkdownField(blank=True,
                                               max_length=30000,
                                               null=True)),
                ('affectedResources',
                 writehat.models.MarkdownField(blank=True,
                                               max_length=30000,
                                               null=True)),
                ('_dreadImpact',
                 models.TextField(
                     blank=True,
                     default=str,
                     max_length=200,
                     null=True,
                     validators=[writehat.validation.isValidJSONList])),
                ('descDamage',
                 writehat.models.MarkdownField(blank=True,
                                               max_length=30000,
                                               null=True)),
                ('descReproducibility',
                 writehat.models.MarkdownField(blank=True,
                                               max_length=30000,
                                               null=True)),
                ('descExploitability',
                 writehat.models.MarkdownField(blank=True,
                                               max_length=30000,
                                               null=True)),
                ('descAffectedUsers',
                 writehat.models.MarkdownField(blank=True,
                                               max_length=30000,
                                               null=True)),
                ('descDiscoverability',
                 writehat.models.MarkdownField(blank=True,
                                               max_length=30000,
                                               null=True)),
            ],
            options={
                'abstract': False,
            },
            bases=(writehat.lib.engagementFinding.EngagementFinding,
                   'writehat.dreadfinding'),
        ),
        migrations.CreateModel(
            name='DREADFindingGroup',
            fields=[
                ('basefindinggroup_ptr',
                 models.OneToOneField(
                     auto_created=True,
                     on_delete=django.db.models.deletion.CASCADE,
                     parent_link=True,
                     primary_key=True,
                     serialize=False,
                     to='writehat.basefindinggroup')),
                ('scoringType',
                 models.CharField(default='DREAD',
                                  editable=False,
                                  max_length=50)),
                ('prefix',
                 models.CharField(default='NT',
                                  max_length=50,
                                  verbose_name='Finding Prefix')),
            ],
            options={
                'abstract': False,
            },
            bases=('writehat.basefindinggroup', ),
        ),
        migrations.CreateModel(
            name='ProactiveDatabaseFinding',
            fields=[
                ('proactivefinding_ptr',
                 models.OneToOneField(
                     auto_created=True,
                     on_delete=django.db.models.deletion.CASCADE,
                     parent_link=True,
                     primary_key=True,
                     serialize=False,
                     to='writehat.proactivefinding')),
            ],
            options={
                'abstract': False,
            },
            bases=(writehat.lib.finding.DatabaseOnlyFinding,
                   'writehat.proactivefinding'),
        ),
        migrations.CreateModel(
            name='ProactiveEngagementFinding',
            fields=[
                ('proactivefinding_ptr',
                 models.OneToOneField(
                     auto_created=True,
                     on_delete=django.db.models.deletion.CASCADE,
                     parent_link=True,
                     primary_key=True,
                     serialize=False,
                     to='writehat.proactivefinding')),
                ('findingGroup', models.UUIDField(editable=False, null=True)),
                ('description',
                 writehat.models.MarkdownField(blank=True,
                                               max_length=30000,
                                               null=True)),
                ('affectedResources',
                 writehat.models.MarkdownField(blank=True,
                                               max_length=30000,
                                               null=True)),
            ],
            options={
                'abstract': False,
            },
            bases=(writehat.lib.engagementFinding.EngagementFinding,
                   'writehat.proactivefinding'),
        ),
        migrations.CreateModel(
            name='ProactiveFindingGroup',
            fields=[
                ('basefindinggroup_ptr',
                 models.OneToOneField(
                     auto_created=True,
                     on_delete=django.db.models.deletion.CASCADE,
                     parent_link=True,
                     primary_key=True,
                     serialize=False,
                     to='writehat.basefindinggroup')),
                ('scoringType',
                 models.CharField(default='PROACTIVE',
                                  editable=False,
                                  max_length=50)),
                ('prefix',
                 models.CharField(default='P',
                                  max_length=50,
                                  verbose_name='Finding Prefix')),
            ],
            options={
                'abstract': False,
            },
            bases=('writehat.basefindinggroup', ),
        ),
    ]
Ejemplo n.º 9
0
class Migration(migrations.Migration):

    initial = True

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

    operations = [
        migrations.CreateModel(
            name='Control',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('messageCounter', models.PositiveIntegerField()),
            ],
        ),
        migrations.CreateModel(
            name='Group',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('groupName', models.CharField(max_length=50)),
                ('publicKey', models.CharField(max_length=10000)),
                ('privateKey', models.CharField(max_length=10000)),
            ],
        ),
        migrations.CreateModel(
            name='GroupMember',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('username', models.CharField(max_length=50)),
                ('groupName', models.CharField(max_length=50)),
            ],
        ),
        migrations.CreateModel(
            name='Message',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('content', models.BinaryField()),
                ('messageNumber', models.PositiveIntegerField()),
                ('groupName', models.CharField(max_length=50)),
                ('poster', models.CharField(max_length=50)),
            ],
        ),
        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')),
                ('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')),
                ('groups',
                 models.ManyToManyField(
                     blank=True,
                     help_text=
                     'The groups this user belongs to. A user will get all permissions granted to each of their groups.',
                     related_name='user_set',
                     related_query_name='user',
                     to='auth.Group',
                     verbose_name='groups')),
                ('user_permissions',
                 models.ManyToManyField(
                     blank=True,
                     help_text='Specific permissions for this user.',
                     related_name='user_set',
                     related_query_name='user',
                     to='auth.Permission',
                     verbose_name='user permissions')),
            ],
            options={
                'verbose_name': 'user',
                'verbose_name_plural': 'users',
                'abstract': False,
            },
            managers=[
                ('objects', django.contrib.auth.models.UserManager()),
            ],
        ),
    ]
Ejemplo n.º 10
0
class Migration(migrations.Migration):

    initial = True

    dependencies = [
        ('contenttypes', '0002_remove_content_type_name'),
        ('auth', '0011_update_proxy_permissions'),
    ]

    operations = [
        migrations.CreateModel(
            name='InscrireUser',
            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=150,
                                  verbose_name='last name')),
                ('is_staff',
                 models.BooleanField(
                     default=False,
                     help_text=
                     'Designates whether the user can log into this admin site.',
                     verbose_name='staff status')),
                ('is_active',
                 models.BooleanField(
                     default=True,
                     help_text=
                     'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.',
                     verbose_name='active')),
                ('date_joined',
                 models.DateTimeField(default=django.utils.timezone.now,
                                      verbose_name='date joined')),
                ('email',
                 models.EmailField(max_length=255,
                                   unique=True,
                                   verbose_name='adresse e-mail')),
                ('role',
                 models.PositiveSmallIntegerField(choices=[(1, 'direction'),
                                                           (2, 'secrétariat'),
                                                           (3, 'professeur'),
                                                           (4, 'vie scolaire'),
                                                           (5, 'intendance'),
                                                           (6, 'étudiant')],
                                                  verbose_name='rôle')),
                ('groups',
                 models.ManyToManyField(
                     blank=True,
                     help_text=
                     'The groups this user belongs to. A user will get all permissions granted to each of their groups.',
                     related_name='user_set',
                     related_query_name='user',
                     to='auth.Group',
                     verbose_name='groups')),
                ('user_permissions',
                 models.ManyToManyField(
                     blank=True,
                     help_text='Specific permissions for this user.',
                     related_name='user_set',
                     related_query_name='user',
                     to='auth.Permission',
                     verbose_name='user permissions')),
            ],
            options={
                'verbose_name': 'user',
                'verbose_name_plural': 'users',
                'abstract': False,
            },
            managers=[
                ('objects', django.contrib.auth.models.UserManager()),
            ],
        ),
        migrations.CreateModel(
            name='Candidat',
            fields=[
                ('genre',
                 models.PositiveSmallIntegerField(
                     choices=[(1, 'homme'), (2, 'femme')])),
                ('last_name',
                 models.CharField(max_length=100, verbose_name='nom')),
                ('first_name',
                 models.CharField(max_length=100, verbose_name='prénom')),
                ('telephone',
                 models.CharField(blank=True,
                                  default='',
                                  max_length=20,
                                  verbose_name='téléphone')),
                ('telephone_mobile',
                 models.CharField(blank=True,
                                  default='',
                                  max_length=20,
                                  verbose_name='téléphone mobile')),
                ('adresse', models.TextField(blank=True,
                                             default='(Inconnue)')),
                ('dossier_parcoursup',
                 models.IntegerField(primary_key=True,
                                     serialize=False,
                                     verbose_name='numéro Parcoursup')),
                ('date_naissance',
                 models.DateField(blank=True,
                                  null=True,
                                  verbose_name='date de naissance')),
                ('ine',
                 models.CharField(blank=True,
                                  max_length=11,
                                  null=True,
                                  unique=True,
                                  verbose_name="INE (numéro d'étudiant)")),
                ('bac_date', models.DateField(blank=True, null=True)),
                ('bac_serie',
                 models.CharField(blank=True, max_length=8, null=True)),
                ('bac_mention',
                 models.PositiveSmallIntegerField(blank=True,
                                                  choices=[(0, 'passable'),
                                                           (1, 'assez bien'),
                                                           (2, 'bien'),
                                                           (3, 'très bien')],
                                                  null=True)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='Commune',
            fields=[
                ('code_insee',
                 models.CharField(max_length=5,
                                  primary_key=True,
                                  serialize=False)),
                ('nom_clair', models.CharField(max_length=200)),
                ('nom_riche', models.CharField(max_length=200)),
                ('libelle', models.CharField(max_length=200)),
            ],
        ),
        migrations.CreateModel(
            name='Etablissement',
            fields=[
                ('numero_uai',
                 inscrire.models.fields.Lettre23Field(length=8,
                                                      primary_key=True,
                                                      serialize=False,
                                                      unique=True,
                                                      verbose_name='UAI')),
                ('nom', models.CharField(max_length=200)),
                ('email',
                 models.EmailField(max_length=254,
                                   verbose_name='adresse e-mail')),
            ],
        ),
        migrations.CreateModel(
            name='Fiche',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('valide', models.BooleanField(default=False)),
                ('etat',
                 models.PositiveSmallIntegerField(choices=[
                     (1, 'fiche à compléter'), (2, 'fiche confirmée'),
                     (3, 'validée par le gestionnaire'), (4, 'annulée')
                 ],
                                                  default=1,
                                                  verbose_name='état')),
                ('candidat',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to='inscrire.Candidat')),
                ('polymorphic_ctype',
                 models.ForeignKey(
                     editable=False,
                     null=True,
                     on_delete=django.db.models.deletion.CASCADE,
                     related_name='polymorphic_inscrire.fiche_set+',
                     to='contenttypes.ContentType')),
            ],
            options={
                'abstract': False,
                'base_manager_name': 'objects',
            },
        ),
        migrations.CreateModel(
            name='Formation',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('nom', models.CharField(max_length=100)),
                ('code_parcoursup', models.SmallIntegerField(unique=True)),
                ('groupe_parcoursup', models.SmallIntegerField()),
                ('slug', models.SlugField(unique=True)),
                ('code_mef', models.CharField(max_length=11)),
                ('etablissement',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to='inscrire.Etablissement')),
            ],
        ),
        migrations.CreateModel(
            name='MefMatiere',
            fields=[
                ('code',
                 models.CharField(max_length=6,
                                  primary_key=True,
                                  serialize=False)),
                ('code_gestion', models.CharField(max_length=10)),
                ('libelle_court', models.CharField(max_length=100)),
                ('libelle_long', models.CharField(max_length=100)),
                ('libelle_edition', models.CharField(max_length=100)),
            ],
        ),
        migrations.CreateModel(
            name='ParcoursupMessageEnvoyeLog',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('date', models.DateTimeField()),
            ],
        ),
        migrations.CreateModel(
            name='Pays',
            fields=[
                ('code_iso2',
                 models.CharField(max_length=2,
                                  primary_key=True,
                                  serialize=False)),
                ('code_iso3', models.CharField(max_length=3, unique=True)),
                ('num_iso', models.PositiveSmallIntegerField(unique=True)),
                ('libelle', models.CharField(max_length=200)),
            ],
        ),
        migrations.CreateModel(
            name='Profession',
            fields=[
                ('code',
                 models.PositiveSmallIntegerField(primary_key=True,
                                                  serialize=False)),
                ('libelle_court', models.CharField(max_length=200)),
                ('libelle_long', models.CharField(max_length=200)),
            ],
        ),
        migrations.CreateModel(
            name='FicheBourse',
            fields=[
                ('fiche_ptr',
                 models.OneToOneField(
                     auto_created=True,
                     on_delete=django.db.models.deletion.CASCADE,
                     parent_link=True,
                     primary_key=True,
                     serialize=False,
                     to='inscrire.Fiche')),
                ('boursier', models.BooleanField(default=False)),
                ('echelon',
                 models.PositiveSmallIntegerField(blank=True,
                                                  null=True,
                                                  verbose_name='échelon')),
                ('enfants_charge',
                 models.PositiveSmallIntegerField(
                     default=1,
                     verbose_name=
                     "nombre d'enfants à charge (y compris l'étudiant)")),
                ('enfants_secondaire',
                 models.PositiveSmallIntegerField(
                     default=0,
                     verbose_name="nombre d'enfants en lycée ou en collège")),
                ('enfants_etablissement',
                 models.PositiveSmallIntegerField(
                     default=1,
                     verbose_name="nombre d'enfants dans l'établissement")),
                ('attribution_bourse',
                 models.FileField(
                     blank=True,
                     null=True,
                     upload_to=inscrire.models.fiches.FicheBourse.
                     _attribution_bourse_upload_to,
                     verbose_name=
                     "copie de l'attestation conditionnelle de bourse")),
            ],
            options={
                'abstract': False,
                'base_manager_name': 'objects',
            },
            bases=('inscrire.fiche', ),
        ),
        migrations.CreateModel(
            name='FicheCesure',
            fields=[
                ('fiche_ptr',
                 models.OneToOneField(
                     auto_created=True,
                     on_delete=django.db.models.deletion.CASCADE,
                     parent_link=True,
                     primary_key=True,
                     serialize=False,
                     to='inscrire.Fiche')),
            ],
            options={
                'abstract': False,
                'base_manager_name': 'objects',
            },
            bases=('inscrire.fiche', ),
        ),
        migrations.CreateModel(
            name='FicheHebergement',
            fields=[
                ('fiche_ptr',
                 models.OneToOneField(
                     auto_created=True,
                     on_delete=django.db.models.deletion.CASCADE,
                     parent_link=True,
                     primary_key=True,
                     serialize=False,
                     to='inscrire.Fiche')),
                ('regime',
                 models.PositiveSmallIntegerField(blank=True,
                                                  choices=[
                                                      (0, 'externe'),
                                                      (1, 'demi-pensionnaire'),
                                                      (2, 'interne externé'),
                                                      (3, 'interne')
                                                  ],
                                                  null=True,
                                                  verbose_name='régime')),
                ('iban',
                 localflavor.generic.models.IBANField(
                     blank=True,
                     include_countries=('FR', ),
                     max_length=34,
                     null=True,
                     use_nordea_extensions=False)),
                ('bic',
                 localflavor.generic.models.BICField(blank=True,
                                                     max_length=11,
                                                     null=True)),
                ('titulaire_compte',
                 models.CharField(blank=True, default='', max_length=200)),
            ],
            options={
                'abstract': False,
                'base_manager_name': 'objects',
            },
            bases=('inscrire.fiche', ),
        ),
        migrations.CreateModel(
            name='FicheInternat',
            fields=[
                ('fiche_ptr',
                 models.OneToOneField(
                     auto_created=True,
                     on_delete=django.db.models.deletion.CASCADE,
                     parent_link=True,
                     primary_key=True,
                     serialize=False,
                     to='inscrire.Fiche')),
                ('message',
                 models.TextField(blank=True,
                                  default='',
                                  verbose_name='demandes particulières')),
            ],
            options={
                'abstract': False,
                'base_manager_name': 'objects',
            },
            bases=('inscrire.fiche', ),
        ),
        migrations.CreateModel(
            name='FicheReglement',
            fields=[
                ('fiche_ptr',
                 models.OneToOneField(
                     auto_created=True,
                     on_delete=django.db.models.deletion.CASCADE,
                     parent_link=True,
                     primary_key=True,
                     serialize=False,
                     to='inscrire.Fiche')),
                ('signature_reglement',
                 models.DateTimeField(
                     blank=True,
                     null=True,
                     verbose_name='signature du règlement intérieur')),
                ('autorisation_parents_eleves',
                 models.BooleanField(default=False)),
            ],
            options={
                'abstract': False,
                'base_manager_name': 'objects',
            },
            bases=('inscrire.fiche', ),
        ),
        migrations.CreateModel(
            name='Voeu',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('etat',
                 models.PositiveSmallIntegerField(
                     choices=[(0, "en liste d'attente"
                               ), (1, 'accepté avec autres vœux en attente'
                                   ), (2, 'accepté définitivement'
                                       ), (3, 'refusé par le candidat')])),
                ('internat', models.BooleanField()),
                ('cesure', models.BooleanField()),
                ('candidat',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to='inscrire.Candidat')),
                ('formation',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to='inscrire.Formation')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='ResponsableLegal',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('genre',
                 models.PositiveSmallIntegerField(
                     choices=[(1, 'homme'), (2, 'femme')])),
                ('last_name',
                 models.CharField(max_length=100, verbose_name='nom')),
                ('first_name',
                 models.CharField(max_length=100, verbose_name='prénom')),
                ('telephone',
                 models.CharField(blank=True,
                                  default='',
                                  max_length=20,
                                  verbose_name='téléphone')),
                ('telephone_mobile',
                 models.CharField(blank=True,
                                  default='',
                                  max_length=20,
                                  verbose_name='téléphone mobile')),
                ('adresse', models.TextField(blank=True,
                                             default='(Inconnue)')),
                ('candidat',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   related_name='responsables',
                                   to='inscrire.Candidat')),
                ('profession',
                 models.ForeignKey(
                     default=99,
                     on_delete=django.db.models.deletion.SET_DEFAULT,
                     to='inscrire.Profession')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='MefOption',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('modalite',
                 models.PositiveSmallIntegerField(choices=[(1, 'obligatoire'),
                                                           (2, 'facultative')],
                                                  verbose_name='modalité')),
                ('rang', models.PositiveSmallIntegerField()),
                ('formation',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to='inscrire.Formation')),
                ('matiere',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to='inscrire.MefMatiere')),
            ],
        ),
        migrations.CreateModel(
            name='HistoriqueVoeu',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('etat',
                 models.PositiveSmallIntegerField(
                     choices=[(0, "en liste d'attente"
                               ), (1, 'accepté avec autres vœux en attente'
                                   ), (2, 'accepté définitivement'
                                       ), (3, 'refusé par le candidat')])),
                ('date', models.DateTimeField()),
                ('voeu',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to='inscrire.Voeu')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='CandidatActionLog',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('message', models.TextField(blank=True, default='')),
                ('date', models.DateTimeField()),
                ('candidat',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to='inscrire.Candidat')),
            ],
        ),
        migrations.AddField(
            model_name='candidat',
            name='commune_naissance',
            field=models.ForeignKey(
                blank=True,
                null=True,
                on_delete=django.db.models.deletion.SET_NULL,
                to='inscrire.Commune'),
        ),
        migrations.AddField(
            model_name='candidat',
            name='nationalite',
            field=models.ForeignKey(
                blank=True,
                null=True,
                on_delete=django.db.models.deletion.SET_NULL,
                related_name='candidats_nationalite',
                to='inscrire.Pays'),
        ),
        migrations.AddField(
            model_name='candidat',
            name='pays_naissance',
            field=models.ForeignKey(
                blank=True,
                null=True,
                on_delete=django.db.models.deletion.SET_NULL,
                related_name='candidats_naissance',
                to='inscrire.Pays'),
        ),
        migrations.AddField(
            model_name='candidat',
            name='user',
            field=models.OneToOneField(
                on_delete=django.db.models.deletion.CASCADE,
                to=settings.AUTH_USER_MODEL),
        ),
        migrations.CreateModel(
            name='ParcoursupUser',
            fields=[
                ('etablissement',
                 models.OneToOneField(
                     on_delete=django.db.models.deletion.CASCADE,
                     primary_key=True,
                     serialize=False,
                     to='inscrire.Etablissement')),
                ('adresse_api', models.URLField(max_length=300)),
                ('remontee_username', models.CharField(max_length=50)),
                ('remontee_password', models.CharField(max_length=128)),
                ('user',
                 models.OneToOneField(
                     on_delete=django.db.models.deletion.CASCADE,
                     to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.CreateModel(
            name='ParcoursupMessageRecuLog',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('date', models.DateTimeField()),
                ('ip_source', models.GenericIPAddressField()),
                ('endpoint', models.CharField(max_length=100)),
                ('message', models.CharField(max_length=200)),
                ('succes', models.BooleanField()),
                ('payload',
                 models.BinaryField(blank=True,
                                    default=b'',
                                    null=True,
                                    verbose_name='données reçues')),
                ('user',
                 models.ForeignKey(
                     blank=True,
                     null=True,
                     on_delete=django.db.models.deletion.SET_NULL,
                     to='inscrire.ParcoursupUser')),
            ],
        ),
        migrations.CreateModel(
            name='FicheScolariteAnterieure',
            fields=[
                ('fiche_ptr',
                 models.OneToOneField(
                     auto_created=True,
                     on_delete=django.db.models.deletion.CASCADE,
                     parent_link=True,
                     primary_key=True,
                     serialize=False,
                     to='inscrire.Fiche')),
                ('classe_terminale',
                 models.CharField(blank=True,
                                  default='',
                                  max_length=20,
                                  verbose_name='classe de terminale suivie')),
                ('specialite_terminale',
                 models.CharField(blank=True,
                                  default='',
                                  max_length=100,
                                  verbose_name='spécialité en terminale')),
                ('autre_formation',
                 models.CharField(blank=True,
                                  default='',
                                  max_length=200,
                                  verbose_name='autre formation')),
                ('etablissement',
                 models.ForeignKey(blank=True,
                                   null=True,
                                   on_delete=django.db.models.deletion.PROTECT,
                                   to='inscrire.Etablissement')),
            ],
            options={
                'abstract': False,
                'base_manager_name': 'objects',
            },
            bases=('inscrire.fiche', ),
        ),
        migrations.CreateModel(
            name='FicheScolarite',
            fields=[
                ('fiche_ptr',
                 models.OneToOneField(
                     auto_created=True,
                     on_delete=django.db.models.deletion.CASCADE,
                     parent_link=True,
                     primary_key=True,
                     serialize=False,
                     to='inscrire.Fiche')),
                ('formation',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to='inscrire.Formation')),
                ('options', models.ManyToManyField(to='inscrire.MefOption')),
            ],
            options={
                'abstract': False,
                'base_manager_name': 'objects',
            },
            bases=('inscrire.fiche', ),
        ),
        migrations.CreateModel(
            name='FicheIdentite',
            fields=[
                ('fiche_ptr',
                 models.OneToOneField(
                     auto_created=True,
                     on_delete=django.db.models.deletion.CASCADE,
                     parent_link=True,
                     primary_key=True,
                     serialize=False,
                     to='inscrire.Fiche')),
                ('photo',
                 models.ImageField(blank=True,
                                   null=True,
                                   upload_to=inscrire.models.fiches.
                                   FicheIdentite._photo_upload_to)),
                ('piece_identite',
                 models.FileField(blank=True,
                                  null=True,
                                  upload_to=inscrire.models.fiches.
                                  FicheIdentite._piece_identite_upload_to)),
                ('commune_naissance_etranger',
                 models.CharField(blank=True, default='', max_length=200)),
                ('commune_naissance',
                 models.ForeignKey(blank=True,
                                   null=True,
                                   on_delete=django.db.models.deletion.PROTECT,
                                   to='inscrire.Commune')),
                ('pays_naissance',
                 models.ForeignKey(blank=True,
                                   null=True,
                                   on_delete=django.db.models.deletion.PROTECT,
                                   to='inscrire.Pays')),
            ],
            options={
                'abstract': False,
                'base_manager_name': 'objects',
            },
            bases=('inscrire.fiche', ),
        ),
        migrations.CreateModel(
            name='BulletinScolaire',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('classe',
                 models.PositiveSmallIntegerField(choices=[(
                     1, 'bulletin de première'), (2,
                                                  'bulletin de terminale')])),
                ('bulletin',
                 models.FileField(upload_to=inscrire.models.fiches.
                                  BulletinScolaire._bulletin_upload_to)),
                ('fiche_scolarite',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to='inscrire.FicheScolariteAnterieure')),
            ],
        ),
    ]
Ejemplo n.º 11
0
class Migration(migrations.Migration):

    initial = True

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

    operations = [
        migrations.CreateModel(
            name='Usuarios',
            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=150,
                                  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')),
                ('foto',
                 models.ImageField(default=None,
                                   upload_to='images',
                                   verbose_name='foto')),
                ('cedula',
                 models.AutoField(db_column='Cedula',
                                  primary_key=True,
                                  serialize=False)),
                ('cargo',
                 models.CharField(choices=[('Subgerente', 'Subgerente'),
                                           ('Director', 'Director'),
                                           ('Coordinador', 'Coordinador'),
                                           ('Líder', 'Líder'),
                                           ('Asesor', 'Asesor'),
                                           ('Técnico', 'Técnico')],
                                  db_column='Cargo',
                                  max_length=50)),
                ('tipo_usuario',
                 models.CharField(choices=[('Administrador', 'Administrador'),
                                           ('Supervisor', 'Supervisor'),
                                           ('Invitado', 'Invitado')],
                                  db_column='Tipo_usuario',
                                  max_length=13)),
                ('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={
                'db_table': 'usuarios',
                'managed': True,
            },
            managers=[
                ('objects', django.contrib.auth.models.UserManager()),
            ],
        ),
        migrations.CreateModel(
            name='Basculas',
            fields=[
                ('cod_bascula',
                 models.CharField(db_column='cod_bascula',
                                  max_length=6,
                                  primary_key=True,
                                  serialize=False)),
                ('descripcion',
                 models.CharField(db_column='descripcion', max_length=100)),
                ('tipos_basculas',
                 models.CharField(choices=[
                     ('Camionera_metalica', 'Camionera_metalica'),
                     ('Foso', 'Foso'), ('Semi_foso', 'Semi_foso'),
                     ('Otra', 'Otra')
                 ],
                                  db_column='tipos_basculas',
                                  max_length=50)),
                ('longitud', models.IntegerField(db_column='longitud')),
                ('marca',
                 models.CharField(choices=[('Cardinal', 'Cardinal'),
                                           ('Autopeso', 'Autopeso')],
                                  db_column='marca',
                                  max_length=50)),
                ('longitud_basculas',
                 models.CharField(choices=[('6_metros', '6_metros'),
                                           ('12_metros', '12_metros'),
                                           ('18_metros', '18_metros'),
                                           ('7_metros', '7_metros'),
                                           ('14_metros', '14_metros'),
                                           ('21_metros', '21_metros'),
                                           ('Especiales', 'Especiales'),
                                           ('Otro', 'Otro'),
                                           ('Registro_Fotografico',
                                            'Registro_Fotografico')],
                                  db_column='longitud_basculas',
                                  max_length=100)),
                ('caracteristicas_basculas',
                 models.CharField(choices=[
                     ('Capacidad', 'Capacidad'),
                     ('Vehiculos_diarios', 'Vehiculos_diarios'),
                     ('Tipos_vehiculos', 'Tipos_vehiculos'),
                     ('Marca_y_Modelo', 'Marca_y_Modelo')
                 ],
                                  db_column='caracteristicas_basculas',
                                  max_length=50)),
            ],
            options={
                'db_table': 'basculas',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='Configuraciones',
            fields=[
                ('codigo',
                 models.CharField(db_column='codigo',
                                  max_length=6,
                                  primary_key=True,
                                  serialize=False)),
                ('tipo', models.CharField(db_column='tipo', max_length=50)),
                ('descripcion',
                 models.CharField(db_column='descripcion', max_length=100)),
                ('estado', models.BinaryField(db_column='estado')),
                ('valor', models.TextField(db_column='valor')),
            ],
            options={
                'db_table': 'configuraciones',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='Contacto',
            fields=[
                ('id_contacto',
                 models.BigIntegerField(db_column='id_contacto',
                                        primary_key=True,
                                        serialize=False)),
                ('nombre', models.CharField(db_column='Nombre',
                                            max_length=100)),
                ('apellidos',
                 models.CharField(db_column='Apellidos', max_length=100)),
                ('movil', models.CharField(db_column='Movil', max_length=15)),
                ('correo', models.CharField(db_column='Correo',
                                            max_length=200)),
                ('telefono',
                 models.CharField(db_column='Telefono', max_length=20)),
                ('Titulo', models.CharField(db_column='Titulo',
                                            max_length=100)),
            ],
            options={
                'db_table': 'contacto',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='Empresas',
            fields=[
                ('nit',
                 models.BigIntegerField(db_column='nit',
                                        primary_key=True,
                                        serialize=False)),
                ('razon_social',
                 models.CharField(db_column='razon_social', max_length=100)),
                ('direccion',
                 models.CharField(db_column='direccion', max_length=100)),
                ('barrio', models.CharField(db_column='barrio',
                                            max_length=100)),
                ('telefono',
                 models.CharField(db_column='telefono', max_length=12)),
                ('geolocalizacion',
                 models.CharField(db_column='geolocalizacion', max_length=50)),
            ],
            options={
                'db_table': 'empresas',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='Indicadores',
            fields=[
                ('id_indicador',
                 models.IntegerField(db_column='id_indicador',
                                     primary_key=True,
                                     serialize=False)),
                ('nombre', models.CharField(db_column='nombre',
                                            max_length=100)),
                ('modelo', models.CharField(db_column='modelo',
                                            max_length=100)),
                ('tipo_indicador',
                 models.CharField(choices=[
                     ('Digital_Cardinal225', 'Digital_Cardinal225'),
                     ('Digital_Cardinal825', 'Digital_Cardinal825'),
                     ('Analoga_Cardinal205', 'Analoga_Cardinal205'),
                     ('Analoga_Cardinal210', 'Analoga_Cardinal210'),
                     ('Analoga_Cardinal225', 'Analoga_Cardinal225'),
                     ('Analoga_Cardinal825', 'Analoga_Cardinal825'),
                     ('Hidraulica_Cardinal210', 'Hidraulica_Cardinal210'),
                     ('Hidraulica_Cardinal225', 'Hidraulica_Cardinal225'),
                     ('Hidraulica_Cardinal825', 'Hidraulica_Cardinal825'),
                     ('Hibrida_Cardinal225', 'Hibrida_Cardinal225'),
                     ('Hibrida_Cardinal825', 'Hibrida_Cardinal825')
                 ],
                                  db_column='tipo_indicador',
                                  max_length=22)),
            ],
            options={
                'db_table': 'indicadores',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='Industrias',
            fields=[
                ('cod_industria',
                 models.IntegerField(db_column='cod_industria',
                                     primary_key=True,
                                     serialize=False)),
                ('tipo_industria',
                 models.CharField(choices=[
                     ('Alimentos', 'Alimentos'),
                     ('Alimentos_procesados', 'Alimentos_procesados'),
                     ('Quimico_y_Farmaceutico', 'Quimico_y_Farmaceutico'),
                     ('Salud', 'Salud'), ('Sector_publico', 'Sector_publico'),
                     ('Metalmecanico_y_Manufactura', 'Sector_Publico'),
                     ('Pesaje_y_Metrologia', 'Pesaje_y_Metrologia'),
                     ('logisitca_y_Transporte', 'logisitca_y_Transporte'),
                     ('Servicios', 'Servicios'), ('Ambiental', 'Ambiental')
                 ],
                                  db_column='tipo_industria',
                                  max_length=50)),
                ('detalles_industria',
                 models.CharField(db_column='detalles_industria',
                                  max_length=100)),
            ],
            options={
                'db_table': 'industrias',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='Medidas',
            fields=[
                ('id',
                 models.IntegerField(db_column='id',
                                     primary_key=True,
                                     serialize=False)),
                ('logn_vigas_logn',
                 models.FloatField(db_column='logn_vigas_logn')),
                ('altura_vigas_logn',
                 models.FloatField(db_column='altura_vigas_logn')),
                ('ancho_vigas_logn',
                 models.FloatField(db_column='ancho_vigas_logn')),
                ('long_vigas_trans',
                 models.FloatField(db_column='long_vigas_trans')),
                ('altura_vigas_trans',
                 models.FloatField(db_column='altura_vigas_trans')),
                ('ancho_vigas_trans',
                 models.FloatField(db_column='ancho_vigas_trans')),
                ('altura_zapatas_viga_long',
                 models.FloatField(db_column='altura_zapatas_viga_long')),
                ('long_puntos_apoyo',
                 models.FloatField(db_column='long_puntos_apoyo')),
                ('altura_zapatas',
                 models.FloatField(db_column='altura_zapatas')),
                ('ancho_zapatas',
                 models.FloatField(db_column='ancho_zapatas')),
                ('largo_zapatas',
                 models.FloatField(db_column='largo_zapatas')),
                ('distancia_zapatas',
                 models.FloatField(db_column='distancia_zapatas')),
                ('altura_obra_civil',
                 models.FloatField(db_column='altura_obra_civil')),
            ],
            options={
                'db_table': 'medidas',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='Obras_civiles',
            fields=[
                ('id_obra',
                 models.BigIntegerField(db_column='obras_civicles',
                                        primary_key=True,
                                        serialize=False)),
                ('tipo_obra',
                 models.CharField(choices=[('Sobre_piso', 'Sobre_piso'),
                                           ('Foso', 'Foso'),
                                           ('Semi foso', 'Semi foso'),
                                           ('Otra', 'Otra')],
                                  db_column='tipo_obra',
                                  max_length=13)),
                ('descripcion',
                 models.CharField(db_column='descripcion', max_length=200)),
            ],
            options={
                'db_table': 'obras_civiles',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='Opotunidades',
            fields=[
                ('cod_registro',
                 models.CharField(db_column='cod_registro',
                                  max_length=8,
                                  primary_key=True,
                                  serialize=False)),
                ('tipo_proyecto',
                 models.CharField(choices=[('Nuevo', 'Nuevo'),
                                           ('Correctivo', 'Correctivo')],
                                  db_column='tipo_proyecto',
                                  max_length=10)),
                ('cod_oportunidad',
                 models.CharField(db_column='cod_oportunidad', max_length=50)),
                ('observaciones',
                 models.CharField(db_column='observaciones', max_length=200)),
                ('cedula',
                 models.ForeignKey(
                     db_column='cedula',
                     on_delete=django.db.models.deletion.DO_NOTHING,
                     to=settings.AUTH_USER_MODEL)),
                ('cod_bascula',
                 models.ForeignKey(
                     db_column='cod_bascula',
                     on_delete=django.db.models.deletion.DO_NOTHING,
                     to='crud.basculas')),
                ('id_indicador',
                 models.ForeignKey(
                     db_column='id_indicador',
                     on_delete=django.db.models.deletion.DO_NOTHING,
                     to='crud.indicadores')),
                ('id_medida',
                 models.ForeignKey(
                     db_column='id_medida',
                     on_delete=django.db.models.deletion.DO_NOTHING,
                     to='crud.medidas')),
                ('id_obra',
                 models.ForeignKey(
                     db_column='id_obra',
                     on_delete=django.db.models.deletion.DO_NOTHING,
                     to='crud.obras_civiles')),
                ('nit',
                 models.ForeignKey(
                     db_column='nit',
                     on_delete=django.db.models.deletion.DO_NOTHING,
                     to='crud.empresas')),
            ],
            options={
                'db_table': 'oportunidades',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='Planos',
            fields=[
                ('id_plano',
                 models.CharField(db_column='id_plano',
                                  max_length=6,
                                  primary_key=True,
                                  serialize=False)),
                ('nombre', models.CharField(db_column='nombre',
                                            max_length=100)),
                ('plano', models.CharField(db_column='plano', max_length=200)),
                ('descripcion',
                 models.CharField(db_column='descripcion', max_length=200)),
            ],
            options={
                'db_table': 'planos',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='Tecnologias',
            fields=[
                ('id_tecnologia',
                 models.IntegerField(db_column='id_tecnologia',
                                     primary_key=True,
                                     serialize=False)),
                ('tipo_tecnologica',
                 models.CharField(choices=[('Digital', 'Digital'),
                                           ('Analoga', 'Analoga'),
                                           ('Hidraulica', 'Hidraulica'),
                                           ('Hibrida', 'Hibrida'),
                                           ('Indicador_marca_modelo_instalado',
                                            'Indicador_marca-modelo_instalado')
                                           ],
                                  db_column='tipo_tecnologia',
                                  max_length=32)),
                ('descripcion',
                 models.CharField(db_column='descripcion', max_length=100)),
            ],
            options={
                'db_table': 'tecnologias',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='Ubicaciones',
            fields=[
                ('cod_ubicacion',
                 models.IntegerField(db_column='cod_ubicacion',
                                     primary_key=True,
                                     serialize=False)),
                ('departamentos',
                 models.CharField(db_column='departamentos', max_length=150)),
                ('municipio',
                 models.CharField(db_column='municipio', max_length=200)),
            ],
            options={
                'db_table': 'ubicaciones',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='Registros_fotograficos',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('fecha_registro',
                 models.DateTimeField(db_column='fecha_registro')),
                ('imagen',
                 models.ImageField(upload_to='images', verbose_name='imagen')),
                ('descripcion',
                 models.CharField(db_column='descripcion', max_length=200)),
                ('cod_registro',
                 models.ForeignKey(
                     db_column='cod_registro',
                     on_delete=django.db.models.deletion.DO_NOTHING,
                     to='crud.opotunidades')),
            ],
            options={
                'db_table': 'registros_fotograficos',
                'managed': True,
            },
        ),
        migrations.AddField(
            model_name='empresas',
            name='cod_industria',
            field=models.ForeignKey(
                db_column='cod_industria',
                on_delete=django.db.models.deletion.DO_NOTHING,
                to='crud.industrias'),
        ),
        migrations.AddField(
            model_name='empresas',
            name='cod_ubicacion',
            field=models.ForeignKey(
                db_column='cod_ubicacion',
                on_delete=django.db.models.deletion.DO_NOTHING,
                to='crud.ubicaciones'),
        ),
        migrations.AddField(
            model_name='empresas',
            name='id_contacto',
            field=models.ForeignKey(
                db_column='id_contacto',
                on_delete=django.db.models.deletion.DO_NOTHING,
                to='crud.contacto'),
        ),
        migrations.AddField(
            model_name='basculas',
            name='id_plano',
            field=models.ForeignKey(
                db_column='id_plano',
                on_delete=django.db.models.deletion.DO_NOTHING,
                to='crud.planos'),
        ),
        migrations.AddField(
            model_name='basculas',
            name='id_tecnologia',
            field=models.ForeignKey(
                db_column='id_tecnologia',
                on_delete=django.db.models.deletion.DO_NOTHING,
                to='crud.tecnologias'),
        ),
    ]
Ejemplo n.º 12
0
class Migration(migrations.Migration):

    initial = True

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

    operations = [
        migrations.CreateModel(
            name='CustomUser',
            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.UUIDField(default=uuid.uuid4,
                                  editable=False,
                                  primary_key=True,
                                  serialize=False)),
                ('friends',
                 models.ManyToManyField(blank=True,
                                        related_name='_customuser_friends_+',
                                        to=settings.AUTH_USER_MODEL)),
                ('groups',
                 models.ManyToManyField(
                     blank=True,
                     help_text=
                     'The groups this user belongs to. A user will get all permissions granted to each of their groups.',
                     related_name='user_set',
                     related_query_name='user',
                     to='auth.Group',
                     verbose_name='groups')),
                ('user_permissions',
                 models.ManyToManyField(
                     blank=True,
                     help_text='Specific permissions for this user.',
                     related_name='user_set',
                     related_query_name='user',
                     to='auth.Permission',
                     verbose_name='user permissions')),
            ],
            options={
                'verbose_name': 'user',
                'verbose_name_plural': 'users',
                'abstract': False,
            },
            managers=[
                ('objects', django.contrib.auth.models.UserManager()),
            ],
        ),
        migrations.CreateModel(
            name='Crypt',
            fields=[
                ('id',
                 models.UUIDField(db_column='crypto_id',
                                  default=uuid.uuid4,
                                  editable=False,
                                  primary_key=True,
                                  serialize=False,
                                  unique=True)),
                ('code', models.UUIDField(default=uuid.uuid4)),
                ('is_chat_password', models.BooleanField(default=False)),
                ('key', models.BinaryField(null=True)),
            ],
        ),
        migrations.CreateModel(
            name='ChatData',
            fields=[
                ('id',
                 models.UUIDField(default=uuid.uuid4,
                                  editable=False,
                                  primary_key=True,
                                  serialize=False)),
                ('created', models.DateTimeField(auto_now_add=True)),
                ('updated', models.DateTimeField(auto_now=True)),
                ('message_file',
                 models.
                 FileField(storage=django.core.files.storage.FileSystemStorage(
                     location=
                     '/home/kamil/Pulpit/message_aplications/SIT-final/mediafiles'
                 ),
                           upload_to='message_storage')),
                ('crypto',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to='messenger.Crypt')),
                ('owner', models.ManyToManyField(to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'ordering': ['-updated'],
            },
        ),
    ]
Ejemplo n.º 13
0
class Migration(migrations.Migration):

    initial = True

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

    operations = [
        migrations.CreateModel(
            name='UserInfo',
            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=30,
                                  verbose_name='last name')),
                ('email',
                 models.EmailField(blank=True,
                                   max_length=254,
                                   verbose_name='email address')),
                ('is_staff',
                 models.BooleanField(
                     default=False,
                     help_text=
                     'Designates whether the user can log into this admin site.',
                     verbose_name='staff status')),
                ('is_active',
                 models.BooleanField(
                     default=True,
                     help_text=
                     'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.',
                     verbose_name='active')),
                ('date_joined',
                 models.DateTimeField(default=django.utils.timezone.now,
                                      verbose_name='date joined')),
                ('nid', models.AutoField(primary_key=True, serialize=False)),
                ('telephone',
                 models.CharField(max_length=11, null=True, unique=True)),
                ('avatar',
                 models.FileField(default='/avatars/default.png',
                                  upload_to='avatars/')),
                ('create_time',
                 models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
            ],
            options={
                'verbose_name': 'user',
                'verbose_name_plural': 'users',
                'abstract': False,
            },
            managers=[
                ('objects', django.contrib.auth.models.UserManager()),
            ],
        ),
        migrations.CreateModel(
            name='Article',
            fields=[
                ('nid', models.AutoField(primary_key=True, serialize=False)),
                ('title', models.CharField(max_length=50,
                                           verbose_name='文章标题')),
                ('desc', models.CharField(max_length=255,
                                          verbose_name='文章描述')),
                ('create_time', models.DateTimeField(verbose_name='创建时间')),
            ],
        ),
        migrations.CreateModel(
            name='Article2Tag',
            fields=[
                ('nid', models.AutoField(primary_key=True, serialize=False)),
                ('article',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to='blog.Article',
                                   verbose_name='文章')),
            ],
        ),
        migrations.CreateModel(
            name='ArticleDetail',
            fields=[
                ('nid', models.AutoField(primary_key=True, serialize=False)),
                ('content', models.TextField()),
                ('article',
                 models.OneToOneField(
                     on_delete=django.db.models.deletion.CASCADE,
                     to='blog.Article')),
            ],
        ),
        migrations.CreateModel(
            name='ArticleUpDown',
            fields=[
                ('nid', models.AutoField(primary_key=True, serialize=False)),
                ('is_up', models.BinaryField(default=True)),
                ('article',
                 models.ForeignKey(null=True,
                                   on_delete=django.db.models.deletion.CASCADE,
                                   to='blog.Article')),
                ('user',
                 models.ForeignKey(null=True,
                                   on_delete=django.db.models.deletion.CASCADE,
                                   to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.CreateModel(
            name='Blog',
            fields=[
                ('nid', models.AutoField(primary_key=True, serialize=False)),
                ('title', models.CharField(max_length=64,
                                           verbose_name='个人博客标题')),
                ('site',
                 models.CharField(max_length=32,
                                  unique=True,
                                  verbose_name='个人博客后缀')),
                ('theme', models.CharField(max_length=32,
                                           verbose_name='博客主题')),
            ],
        ),
        migrations.CreateModel(
            name='Category',
            fields=[
                ('nid', models.AutoField(primary_key=True, serialize=False)),
                ('title', models.CharField(max_length=32,
                                           verbose_name='分类标题')),
                ('blog',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to='blog.Blog',
                                   verbose_name='所属博客')),
            ],
        ),
        migrations.CreateModel(
            name='Comment',
            fields=[
                ('nid', models.AutoField(primary_key=True, serialize=False)),
                ('content',
                 models.CharField(max_length=255, verbose_name='评论内容')),
                ('create_time',
                 models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
                ('article',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to='blog.Article',
                                   verbose_name='评论文章')),
                ('parent_comment',
                 models.ForeignKey(null=True,
                                   on_delete=django.db.models.deletion.CASCADE,
                                   to='blog.Comment')),
                ('user',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to=settings.AUTH_USER_MODEL,
                                   verbose_name='评论者')),
            ],
        ),
        migrations.CreateModel(
            name='Tag',
            fields=[
                ('nid', models.AutoField(primary_key=True, serialize=False)),
                ('title', models.CharField(max_length=32,
                                           verbose_name='标签名称')),
                ('blog',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to='blog.Blog',
                                   verbose_name='所属博客')),
            ],
        ),
        migrations.AddField(
            model_name='article2tag',
            name='tag',
            field=models.ForeignKey(
                on_delete=django.db.models.deletion.CASCADE,
                to='blog.Tag',
                verbose_name='标签'),
        ),
        migrations.AddField(
            model_name='article',
            name='category',
            field=models.ForeignKey(
                null=True,
                on_delete=django.db.models.deletion.CASCADE,
                to='blog.Category'),
        ),
        migrations.AddField(
            model_name='article',
            name='tags',
            field=models.ManyToManyField(through='blog.Article2Tag',
                                         to='blog.Tag'),
        ),
        migrations.AddField(
            model_name='article',
            name='user',
            field=models.ForeignKey(
                on_delete=django.db.models.deletion.CASCADE,
                to=settings.AUTH_USER_MODEL,
                verbose_name='作者'),
        ),
        migrations.AddField(
            model_name='userinfo',
            name='blog',
            field=models.OneToOneField(
                null=True,
                on_delete=django.db.models.deletion.CASCADE,
                to='blog.Blog'),
        ),
        migrations.AddField(
            model_name='userinfo',
            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='userinfo',
            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.AlterUniqueTogether(
            name='articleupdown',
            unique_together=set([('article', 'user')]),
        ),
        migrations.AlterUniqueTogether(
            name='article2tag',
            unique_together=set([('article', 'tag')]),
        ),
    ]
class Migration(migrations.Migration):

    initial = True

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

    operations = [
        migrations.CreateModel(
            name='HubUser',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('password',
                 models.CharField(max_length=128, verbose_name='password')),
                ('last_login',
                 models.DateTimeField(blank=True,
                                      null=True,
                                      verbose_name='last login')),
                ('is_superuser',
                 models.BooleanField(
                     default=False,
                     help_text=
                     'Designates that this user has all permissions without explicitly assigning them.',
                     verbose_name='superuser status')),
                ('username',
                 models.CharField(
                     error_messages={
                         'unique': 'A user with that username already exists.'
                     },
                     help_text=
                     'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.',
                     max_length=150,
                     unique=True,
                     validators=[
                         django.contrib.auth.validators.
                         UnicodeUsernameValidator()
                     ],
                     verbose_name='username')),
                ('first_name',
                 models.CharField(blank=True,
                                  max_length=30,
                                  verbose_name='first name')),
                ('last_name',
                 models.CharField(blank=True,
                                  max_length=150,
                                  verbose_name='last name')),
                ('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')),
                ('totp_secret',
                 models.BinaryField(default=hub_app.authlib.totp.token.
                                    create_encrypted_random_totp_secret,
                                    help_text='Encrypted TOTP Secret',
                                    max_length=1024,
                                    null=True,
                                    verbose_name='TOTP Secret')),
                ('groups',
                 models.ManyToManyField(
                     blank=True,
                     help_text=
                     'The groups this user belongs to. A user will get all permissions granted to each of their groups.',
                     related_name='user_set',
                     related_query_name='user',
                     to='auth.Group',
                     verbose_name='groups')),
                ('user_permissions',
                 models.ManyToManyField(
                     blank=True,
                     help_text='Specific permissions for this user.',
                     related_name='user_set',
                     related_query_name='user',
                     to='auth.Permission',
                     verbose_name='user permissions')),
            ],
            options={
                'verbose_name': 'user',
                'verbose_name_plural': 'users',
                'abstract': False,
            },
            managers=[
                ('objects', django.contrib.auth.models.UserManager()),
            ],
        ),
        migrations.CreateModel(
            name='BurnedOtp',
            fields=[
                ('uuid',
                 models.UUIDField(default=uuid.uuid4,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='UUID')),
                ('token',
                 models.CharField(max_length=6, verbose_name='OTP Token')),
                ('burned_timestamp',
                 models.DateTimeField(default=django.utils.timezone.now,
                                      verbose_name='Burned Date/Time')),
                ('user',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to=settings.AUTH_USER_MODEL,
                                   verbose_name='User')),
            ],
            options={
                'verbose_name': 'Burned One Time Password',
                'verbose_name_plural': 'Burned One Time Passwords',
                'permissions': (),
                'default_permissions': (),
                'unique_together': {('user', 'token')},
            },
        ),
    ]
Ejemplo n.º 15
0
class Migration(migrations.Migration):

    initial = True

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

    operations = [
        migrations.CreateModel(
            name='User',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('password', models.CharField(max_length=128, verbose_name='password')),
                ('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')),
                ('is_superuser', models.BooleanField(default=False, help_text='Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')),
                ('username', models.CharField(error_messages={'unique': 'A user with that username already exists.'}, help_text='Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, validators=[django.contrib.auth.validators.ASCIIUsernameValidator()], verbose_name='username')),
                ('first_name', models.CharField(blank=True, max_length=30, verbose_name='first name')),
                ('last_name', models.CharField(blank=True, max_length=30, verbose_name='last name')),
                ('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')),
                ('display_name', models.CharField(max_length=50)),
                ('key', models.CharField(db_index=True, default=credocommon.helpers.generate_token, max_length=255, unique=True)),
                ('email', models.EmailField(max_length=254, unique=True)),
                ('email_confirmation_token', models.CharField(blank=True, max_length=255)),
                ('language', models.CharField(default='en', max_length=10)),
                ('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,
                'verbose_name': 'user',
                'verbose_name_plural': 'users',
            },
            managers=[
                ('objects', django.contrib.auth.models.UserManager()),
            ],
        ),
        migrations.CreateModel(
            name='Detection',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('accuracy', models.FloatField()),
                ('altitude', models.FloatField()),
                ('frame_content', models.BinaryField(blank=True, null=True)),
                ('height', models.IntegerField()),
                ('width', models.IntegerField()),
                ('d_id', models.IntegerField()),
                ('latitude', models.FloatField()),
                ('longitude', models.FloatField()),
                ('provider', models.CharField(max_length=24)),
                ('timestamp', models.BigIntegerField(db_index=True)),
                ('time_received', models.BigIntegerField()),
                ('source', models.CharField(default='unspecified', max_length=50)),
                ('visible', models.BooleanField(default=True)),
            ],
        ),
        migrations.CreateModel(
            name='Device',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('device_id', models.CharField(max_length=255)),
                ('device_type', models.CharField(default='phone_android', max_length=255)),
                ('device_model', models.CharField(max_length=255)),
                ('system_version', models.CharField(max_length=255)),
                ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.CreateModel(
            name='Ping',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('timestamp', models.BigIntegerField(db_index=True)),
                ('delta_time', models.IntegerField(blank=True, null=True)),
                ('device', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='credocommon.Device')),
                ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.CreateModel(
            name='Team',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=255, unique=True)),
            ],
        ),
        migrations.AddField(
            model_name='detection',
            name='device',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='credocommon.Device'),
        ),
        migrations.AddField(
            model_name='detection',
            name='team',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='credocommon.Team'),
        ),
        migrations.AddField(
            model_name='detection',
            name='user',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL),
        ),
        migrations.AddField(
            model_name='user',
            name='team',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='credocommon.Team'),
        ),
        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'),
        ),
    ]
Ejemplo n.º 16
0
class Migration(migrations.Migration):

    initial = True

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

    operations = [
        migrations.CreateModel(
            name='Users',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('password', models.CharField(max_length=128, verbose_name='password')),
                ('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')),
                ('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')),
                ('permissions', models.TextField(default=None, null=True, verbose_name='permissions')),
                ('first_name', models.CharField(default=None, max_length=255, null=True, unique=True, verbose_name='first_name')),
                ('last_name', models.CharField(default=None, max_length=255, null=True, verbose_name='last_name')),
                ('last_login', models.DateTimeField(default=None, null=True, verbose_name='last_login')),
                ('created_at', models.DateTimeField(default=datetime.datetime.now, verbose_name='created_at')),
                ('updated_at', models.DateTimeField(default=datetime.datetime.now, verbose_name='updated_at')),
                ('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={
                'db_table': 'users',
                'managed': True,
            },
            managers=[
                ('objects', django.contrib.auth.models.UserManager()),
            ],
        ),
        migrations.CreateModel(
            name='Collections',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=255, verbose_name='name')),
                ('encoding', models.CharField(max_length=255, verbose_name='encoding')),
                ('handler', models.CharField(max_length=255, verbose_name='handler')),
                ('created_at', models.DateTimeField(default=datetime.datetime.now, verbose_name='created_at')),
                ('updated_at', models.DateTimeField(default=datetime.datetime.now, verbose_name='updated_at')),
                ('owner_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'db_table': 'collections',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='Documents',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=255, verbose_name='name')),
                ('external_name', models.CharField(max_length=255, verbose_name='external_name')),
                ('text', models.TextField(verbose_name='text')),
                ('type', models.CharField(default=None, max_length=128, null=True, verbose_name='type')),
                ('data_text', models.TextField(default=None, null=True, verbose_name='data_text')),
                ('data_binary', models.BinaryField(default=None, null=True, verbose_name='data_binary')),
                ('visualisation_options', models.TextField(default=None, null=True, verbose_name='visualisation_options')),
                ('metadata', models.TextField(default=None, null=True, verbose_name='metadata')),
                ('encoding', models.CharField(max_length=20, verbose_name='encoding')),
                ('handler', models.CharField(default=None, max_length=256, null=True, verbose_name='handler')),
                ('created_at', models.DateTimeField(default=datetime.datetime.now, verbose_name='created_at')),
                ('updated_at', models.DateTimeField(default=datetime.datetime.now, verbose_name='updated_at')),
                ('version', models.IntegerField(default=1, verbose_name='version')),
                ('updated_by', models.CharField(max_length=255, verbose_name='updated_by')),
                ('collection_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='clarin_backend.collections')),
                ('owner_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'db_table': 'documents',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='SharedCollections',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('confirmed', models.SmallIntegerField(default=0, verbose_name='confirmed')),
                ('confirmation_code', models.CharField(default=None, max_length=255, null=True, verbose_name='confirmation_code')),
                ('created_at', models.DateTimeField(default=datetime.datetime.now, verbose_name='created_at')),
                ('updated_at', models.DateTimeField(default=datetime.datetime.now, verbose_name='updated_at')),
                ('collection_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='clarin_backend.collections')),
                ('fromfield', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='fromfield', to=settings.AUTH_USER_MODEL)),
                ('tofield', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='tofield', to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'db_table': 'shared_collections',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='OpenDocuments',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_at', models.DateTimeField(default=datetime.datetime.now, verbose_name='created_at')),
                ('updated_at', models.DateTimeField(default=datetime.datetime.now, verbose_name='updated_at')),
                ('db_interactions', models.IntegerField(verbose_name='db_interactions')),
                ('annotator_type', models.CharField(max_length=255, verbose_name='annotator_type')),
                ('collection_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='clarin_backend.collections')),
                ('document_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='clarin_backend.documents')),
                ('user_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'db_table': 'open_documents',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='CoreferenceAnnotators',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('language', models.CharField(default=None, max_length=255, null=True, verbose_name='language')),
                ('annotation_type', models.CharField(default=None, max_length=255, null=True, verbose_name='annotation_type')),
                ('alternative', models.CharField(default=None, max_length=255, null=True, verbose_name='alternative')),
                ('created_at', models.DateTimeField(default=datetime.datetime.now, verbose_name='created_at')),
                ('updated_at', models.DateTimeField(default=datetime.datetime.now, verbose_name='updated_at')),
                ('user_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'db_table': 'coreference_annotators',
            },
        ),
        migrations.CreateModel(
            name='ButtonAnnotators',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('language', models.CharField(default=None, max_length=255, null=True, verbose_name='language')),
                ('annotation_type', models.CharField(default=None, max_length=255, null=True, verbose_name='annotation_type')),
                ('attribute', models.CharField(default=None, max_length=255, null=True, verbose_name='attribute')),
                ('alternative', models.CharField(default=None, max_length=255, null=True, verbose_name='alternative')),
                ('created_at', models.DateTimeField(default=datetime.datetime.now, verbose_name='created_at')),
                ('updated_at', models.DateTimeField(default=datetime.datetime.now, verbose_name='updated_at')),
                ('user_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'db_table': 'button_annotators',
            },
        ),
    ]
Ejemplo n.º 17
0
class Migration(migrations.Migration):

    initial = True

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

    operations = [
        migrations.CreateModel(
            name='User',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('password',
                 models.CharField(max_length=128, verbose_name='password')),
                ('last_login',
                 models.DateTimeField(blank=True,
                                      null=True,
                                      verbose_name='last login')),
                ('is_superuser',
                 models.BooleanField(
                     default=False,
                     help_text=
                     'Designates that this user has all permissions without explicitly assigning them.',
                     verbose_name='superuser status')),
                ('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')),
                ('accepted_terms_at',
                 models.DateTimeField(blank=True, null=True)),
                ('authorization_id',
                 models.CharField(blank=True, max_length=500, null=True)),
                ('authorization_guid',
                 models.UUIDField(default=None, null=True, unique=True)),
                ('authorization_directory',
                 models.CharField(blank=True, max_length=100, null=True)),
                ('authorization_email',
                 models.EmailField(blank=True, max_length=254, null=True)),
                ('display_name',
                 models.CharField(blank=True, max_length=500, null=True)),
                ('groups',
                 models.ManyToManyField(
                     blank=True,
                     help_text=
                     'The groups this user belongs to. A user will get all permissions granted to each of their groups.',
                     related_name='user_set',
                     related_query_name='user',
                     to='auth.Group',
                     verbose_name='groups')),
                ('user_permissions',
                 models.ManyToManyField(
                     blank=True,
                     help_text='Specific permissions for this user.',
                     related_name='user_set',
                     related_query_name='user',
                     to='auth.Permission',
                     verbose_name='user permissions')),
            ],
            options={
                'verbose_name': 'user',
                'verbose_name_plural': 'users',
                'abstract': False,
            },
            managers=[
                ('objects', django.contrib.auth.models.UserManager()),
            ],
        ),
        migrations.CreateModel(
            name='Location',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('name',
                 models.CharField(blank=True, max_length=255, unique=True)),
            ],
        ),
        migrations.CreateModel(
            name='PreparedPdf',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('created_date', models.DateTimeField(auto_now_add=True)),
                ('data', models.BinaryField()),
            ],
        ),
        migrations.CreateModel(
            name='Region',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('name', models.CharField(blank=True, max_length=255)),
            ],
        ),
        migrations.CreateModel(
            name='TicketResponse',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('created_date', models.DateTimeField(auto_now_add=True)),
                ('updated_date', models.DateTimeField(auto_now=True)),
                ('emailed_date', models.DateTimeField(blank=True, null=True)),
                ('result',
                 django.contrib.postgres.fields.jsonb.JSONField(blank=True,
                                                                null=True)),
                ('first_name',
                 models.CharField(blank=True, max_length=255, null=True)),
                ('middle_name',
                 models.CharField(blank=True, max_length=255, null=True)),
                ('last_name',
                 models.CharField(blank=True, max_length=255, null=True)),
                ('email',
                 models.CharField(blank=True, max_length=255, null=True)),
                ('hearing_attendance',
                 models.CharField(blank=True, max_length=255, null=True)),
                ('ticket_number',
                 models.CharField(blank=True, max_length=255, null=True)),
                ('ticket_date', models.DateField(blank=True, null=True)),
                ('deadline_date', models.DateField(blank=True, null=True)),
                ('dispute_type',
                 models.CharField(blank=True, max_length=255, null=True)),
                ('pdf_filename',
                 models.CharField(blank=True, max_length=255, null=True)),
                ('printed_date', models.DateTimeField(blank=True, null=True)),
                ('archived_date', models.DateTimeField(blank=True, null=True)),
                ('archived_by',
                 models.ForeignKey(
                     blank=True,
                     null=True,
                     on_delete=django.db.models.deletion.SET_NULL,
                     related_name='user_ticket_archived',
                     to=settings.AUTH_USER_MODEL)),
                ('hearing_location',
                 models.ForeignKey(
                     blank=True,
                     null=True,
                     on_delete=django.db.models.deletion.SET_NULL,
                     related_name='location_ticket',
                     to='api.Location')),
                ('prepared_pdf',
                 models.ForeignKey(
                     blank=True,
                     null=True,
                     on_delete=django.db.models.deletion.SET_NULL,
                     related_name='pdf_ticket',
                     to='api.PreparedPdf')),
                ('printed_by',
                 models.ForeignKey(
                     blank=True,
                     null=True,
                     on_delete=django.db.models.deletion.SET_NULL,
                     related_name='user_ticket_printed',
                     to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.AddField(
            model_name='location',
            name='region',
            field=models.ForeignKey(
                blank=True,
                null=True,
                on_delete=django.db.models.deletion.SET_NULL,
                related_name='region_location',
                to='api.Region'),
        ),
    ]
Ejemplo n.º 18
0
class Migration(migrations.Migration):

    initial = True

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

    operations = [
        migrations.CreateModel(
            name='User',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('password',
                 models.CharField(max_length=128, verbose_name='password')),
                ('last_login',
                 models.DateTimeField(blank=True,
                                      null=True,
                                      verbose_name='last login')),
                ('is_superuser',
                 models.BooleanField(
                     default=False,
                     help_text=
                     'Designates that this user has all permissions without explicitly assigning them.',
                     verbose_name='superuser status')),
                ('username',
                 models.CharField(
                     error_messages={
                         'unique': 'A user with that username already exists.'
                     },
                     help_text=
                     'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.',
                     max_length=150,
                     unique=True,
                     validators=[
                         django.contrib.auth.validators.
                         UnicodeUsernameValidator()
                     ],
                     verbose_name='username')),
                ('first_name',
                 models.CharField(blank=True,
                                  max_length=150,
                                  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')),
                ('age',
                 models.IntegerField(
                     blank=True,
                     null=True,
                     validators=[
                         django.core.validators.MinValueValidator(18),
                         django.core.validators.MaxValueValidator(120)
                     ])),
                ('gender',
                 models.CharField(blank=True,
                                  choices=[('', '---'), ('m', 'Male'),
                                           ('f', 'Female'),
                                           ('o', 'Non-Binary')],
                                  max_length=300,
                                  null=True)),
                ('income', models.FloatField(blank=True, null=True)),
                ('education',
                 models.CharField(blank=True,
                                  choices=[('', '---'),
                                           ('1', 'Primary (middle) school'),
                                           ('2', 'Secondary (high) school'),
                                           ('3', 'Undergraduate degree'),
                                           ('4', 'Graduate degree'),
                                           ('6', 'Other')],
                                  max_length=300,
                                  null=True)),
                ('veteran', models.BooleanField(blank=True, null=True)),
                ('empathy',
                 models.IntegerField(
                     blank=True,
                     null=True,
                     validators=[
                         django.core.validators.MinValueValidator(1),
                         django.core.validators.MaxValueValidator(10)
                     ])),
                ('risk',
                 models.IntegerField(
                     blank=True,
                     null=True,
                     validators=[
                         django.core.validators.MinValueValidator(1),
                         django.core.validators.MaxValueValidator(10)
                     ])),
                ('altruism',
                 models.IntegerField(
                     blank=True,
                     null=True,
                     validators=[
                         django.core.validators.MinValueValidator(1),
                         django.core.validators.MaxValueValidator(10)
                     ])),
                ('completionCode',
                 models.CharField(default='XAmfJQdElk0sC3UF5kDb2RTS3JiTJuso',
                                  help_text='MTurk Confirmation Code',
                                  max_length=32)),
            ],
            managers=[
                ('objects', django.contrib.auth.models.UserManager()),
            ],
        ),
        migrations.CreateModel(
            name='Agent',
            fields=[
                ('uuid',
                 models.UUIDField(default=uuid.uuid4,
                                  help_text='Unique agent ID',
                                  primary_key=True,
                                  serialize=False)),
                ('agentType',
                 models.CharField(blank=True,
                                  default=str,
                                  max_length=100,
                                  null=True)),
                ('agentBlob', models.BinaryField(null=True)),
                ('created', models.DateTimeField(auto_now_add=True)),
                ('updateDB', models.BooleanField(default=False)),
            ],
        ),
        migrations.CreateModel(
            name='Game',
            fields=[
                ('uuid',
                 models.UUIDField(default=uuid.uuid4,
                                  help_text='Unique game ID',
                                  primary_key=True,
                                  serialize=False)),
                ('date', models.DateTimeField(auto_now_add=True)),
                ('userMove', models.IntegerField(blank=True, null=True)),
                ('agentMove', models.IntegerField(blank=True, null=True)),
                ('userMoves',
                 models.CharField(blank=True,
                                  default=str,
                                  max_length=300,
                                  null=True)),
                ('userTimes',
                 models.CharField(blank=True,
                                  default=str,
                                  max_length=300,
                                  null=True)),
                ('agentMoves',
                 models.CharField(blank=True,
                                  default=str,
                                  max_length=300,
                                  null=True)),
                ('userRole',
                 models.CharField(blank=True,
                                  choices=[('A', 'A'), ('B', 'B')],
                                  max_length=1,
                                  null=True)),
                ('agentRole',
                 models.CharField(blank=True,
                                  choices=[('A', 'A'), ('B', 'B')],
                                  max_length=1,
                                  null=True)),
                ('userScore',
                 models.IntegerField(blank=True, default=0, null=True)),
                ('agentScore',
                 models.IntegerField(blank=True, default=0, null=True)),
                ('complete', models.BooleanField(default=False)),
                ('nIter', models.IntegerField(default=5)),
                ('capital', models.IntegerField(default=10)),
                ('matchFactor', models.FloatField(default=3)),
                ('seed', models.IntegerField(default=0)),
                ('agent',
                 models.ForeignKey(blank=True,
                                   null=True,
                                   on_delete=django.db.models.deletion.CASCADE,
                                   to='game.agent')),
                ('user',
                 models.ForeignKey(blank=True,
                                   null=True,
                                   on_delete=django.db.models.deletion.CASCADE,
                                   to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.AddField(
            model_name='user',
            name='currentGame',
            field=models.ForeignKey(
                blank=True,
                null=True,
                on_delete=django.db.models.deletion.SET_NULL,
                related_name='currentGame',
                to='game.game'),
        ),
        migrations.AddField(
            model_name='user',
            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='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'),
        ),
    ]
Ejemplo n.º 19
0
class Migration(migrations.Migration):
    initial = True

    dependencies = [
        ('auth', '0012_alter_user_first_name_max_length'),
        ('contenttypes', '0002_remove_content_type_name'),
    ]

    operations = [
        migrations.CreateModel(
            name='User',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('password', models.CharField(max_length=128, verbose_name='password')),
                ('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')),
                ('is_superuser', models.BooleanField(default=False,
                                                     help_text='Designates that this user has all permissions without explicitly assigning them.',
                                                     verbose_name='superuser status')),
                ('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=150, 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')),
                ('newsletter_signup', models.BinaryField(blank=True, null=True)),
                ('blocked_on', models.DateTimeField(blank=True, null=True)),
                ('blocked_till', models.DateTimeField(blank=True, null=True)),
                ('deleted_on', models.DateTimeField(blank=True, null=True)),
                ('blocked_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL,
                                                 related_name='blocked_users', to=settings.AUTH_USER_MODEL)),
                ('deleted_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL,
                                                 related_name='deleted_users', to=settings.AUTH_USER_MODEL)),
                ('groups', models.ManyToManyField(blank=True,
                                                  help_text='The groups this user belongs to. A user will get all permissions granted to each of their groups.',
                                                  related_name='user_set', related_query_name='user', to='auth.Group',
                                                  verbose_name='groups')),
                ('user_permissions', models.ManyToManyField(blank=True, help_text='Specific permissions for this user.',
                                                            related_name='user_set', related_query_name='user',
                                                            to='auth.Permission', verbose_name='user permissions')),
            ],
            options={
                'verbose_name': 'user',
                'verbose_name_plural': 'users',
                'abstract': False,
            },
            managers=[
                ('objects', django.contrib.auth.models.UserManager()),
            ],
        ),
        migrations.CreateModel(
            name='Category',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=120)),
                ('image', models.ImageField(upload_to='categories/')),
            ],
        ),
        migrations.CreateModel(
            name='Measurment',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('full_name', models.CharField(max_length=120)),
                ('short_name', models.CharField(max_length=6)),
            ],
        ),
        migrations.CreateModel(
            name='Recipe',
            fields=[
                ('vote_score', models.IntegerField(db_index=True, default=0)),
                ('num_vote_up', models.PositiveIntegerField(db_index=True, default=0)),
                ('num_vote_down', models.PositiveIntegerField(db_index=True, default=0)),
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('slug', models.SlugField(blank=True, null=True)),
                ('name', models.CharField(max_length=120)),
                ('content', models.TextField()),
                (
                    'icon',
                    models.ImageField(upload_to='recipes_icons', validators=[popcorn.models.validate_recipe_icon])),
                ('created_on', models.DateTimeField(auto_now_add=True)),
                ('last_modified', models.DateTimeField(auto_now=True)),
                ('preparation_time', models.PositiveIntegerField()),
                ('servings_count', models.PositiveIntegerField()),
                ('difficulty', models.IntegerField(blank=True,
                                                   choices=[(1, 'Bardzo łatwa'), (2, 'Łatwa'), (3, 'Średnia'),
                                                            (4, 'Trudna'), (5, 'Bardzo trudna')], default=3,
                                                   null=True)),
                ('hidden_on', models.DateTimeField(blank=True, null=True)),
                ('deleted_on', models.DateTimeField(blank=True, null=True)),
                ('author', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL,
                                             related_name='authored_recipes', to=settings.AUTH_USER_MODEL)),
                ('categories', models.ManyToManyField(blank=True, null=True, to='popcorn.Category')),
                ('deleted_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL,
                                                 related_name='deleted_recipes', to=settings.AUTH_USER_MODEL)),
                ('hidden_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL,
                                                related_name='hidden_recipes', to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='Ingredient',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=120)),
                ('count', models.PositiveIntegerField()),
                ('measurment',
                 models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to='popcorn.measurment')),
                ('recipe', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='popcorn.recipe')),
            ],
        ),
        migrations.CreateModel(
            name='Comment',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('object_id', models.PositiveIntegerField()),
                ('content', models.TextField()),
                ('created_on', models.DateTimeField(auto_now_add=True)),
                ('last_modified', models.DateTimeField(auto_now=True)),
                ('deleted_on', models.DateTimeField()),
                ('author', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL,
                                             related_name='authored_comments', to=settings.AUTH_USER_MODEL)),
                ('comment_parent', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL,
                                                     to='contenttypes.contenttype')),
                ('deleted_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL,
                                                 related_name='comments_deleted', to=settings.AUTH_USER_MODEL)),
            ],
        ),
    ]
Ejemplo n.º 20
0
class Migration(migrations.Migration):

    initial = True

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

    operations = [
        migrations.CreateModel(
            name='User',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('password',
                 models.CharField(max_length=128, verbose_name='password')),
                ('last_login',
                 models.DateTimeField(blank=True,
                                      null=True,
                                      verbose_name='last login')),
                ('is_superuser',
                 models.BooleanField(
                     default=False,
                     help_text=
                     'Designates that this user has all permissions without explicitly assigning them.',
                     verbose_name='superuser status')),
                ('username',
                 models.CharField(
                     error_messages={
                         'unique': 'A user with that username already exists.'
                     },
                     help_text=
                     'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.',
                     max_length=150,
                     unique=True,
                     validators=[
                         django.contrib.auth.validators.
                         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=30,
                                  verbose_name='last name')),
                ('email',
                 models.EmailField(blank=True,
                                   max_length=254,
                                   verbose_name='email address')),
                ('is_staff',
                 models.BooleanField(
                     default=False,
                     help_text=
                     'Designates whether the user can log into this admin site.',
                     verbose_name='staff status')),
                ('is_active',
                 models.BooleanField(
                     default=True,
                     help_text=
                     'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.',
                     verbose_name='active')),
                ('date_joined',
                 models.DateTimeField(default=django.utils.timezone.now,
                                      verbose_name='date joined')),
                ('DID', models.TextField(blank=True,
                                         max_length=60,
                                         unique=True)),
                ('verkey', models.BinaryField(blank=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,
            },
            managers=[
                ('objects', django.contrib.auth.models.UserManager()),
            ],
        ),
        migrations.CreateModel(
            name='DoingBusinessAs',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('create_timestamp',
                 models.DateTimeField(auto_now_add=True, null=True)),
                ('update_timestamp',
                 models.DateTimeField(auto_now=True, null=True)),
                ('dbaName', models.CharField(max_length=255)),
                ('effectiveDate',
                 models.DateField(default=django.utils.timezone.now)),
                ('endDate', models.DateField(blank=True, null=True)),
            ],
            options={
                'db_table': 'DOING_BUSINESS_AS',
            },
        ),
        migrations.CreateModel(
            name='InactiveClaimReason',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('create_timestamp',
                 models.DateTimeField(auto_now_add=True, null=True)),
                ('update_timestamp',
                 models.DateTimeField(auto_now=True, null=True)),
                ('shortReason',
                 models.CharField(blank=True, max_length=255, null=True)),
                ('reason',
                 models.CharField(blank=True, max_length=255, null=True)),
                ('effectiveDate',
                 models.DateField(default=django.utils.timezone.now)),
                ('endDate', models.DateField(blank=True, null=True)),
                ('displayOrder', models.IntegerField()),
            ],
            options={
                'db_table': 'INACTIVE_CLAIM_REASON',
            },
        ),
        migrations.CreateModel(
            name='IssuerService',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('create_timestamp',
                 models.DateTimeField(auto_now_add=True, null=True)),
                ('update_timestamp',
                 models.DateTimeField(auto_now=True, null=True)),
                ('name', models.CharField(max_length=255)),
                ('issuerOrgTLA', models.CharField(max_length=255)),
                ('issuerOrgURL',
                 models.CharField(blank=True, max_length=255, null=True)),
                ('DID', models.CharField(max_length=255)),
                ('effectiveDate',
                 models.DateField(default=django.utils.timezone.now)),
                ('endDate', models.DateField(blank=True, null=True)),
            ],
            options={
                'db_table': 'ISSUER_SERVICE',
            },
        ),
        migrations.CreateModel(
            name='Jurisdiction',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('create_timestamp',
                 models.DateTimeField(auto_now_add=True, null=True)),
                ('update_timestamp',
                 models.DateTimeField(auto_now=True, null=True)),
                ('abbrv', models.CharField(max_length=25)),
                ('name', models.CharField(max_length=1000)),
                ('displayOrder', models.IntegerField()),
                ('isOnCommonList', models.BooleanField()),
                ('effectiveDate',
                 models.DateField(default=django.utils.timezone.now)),
                ('endDate', models.DateField(blank=True, null=True)),
            ],
            options={
                'db_table': 'JURISDICTION',
            },
        ),
        migrations.CreateModel(
            name='Location',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('create_timestamp',
                 models.DateTimeField(auto_now_add=True, null=True)),
                ('update_timestamp',
                 models.DateTimeField(auto_now=True, null=True)),
                ('addressee',
                 models.CharField(blank=True, max_length=255, null=True)),
                ('addlDeliveryInfo',
                 models.CharField(blank=True, max_length=255, null=True)),
                ('unitNumber',
                 models.CharField(blank=True, max_length=255, null=True)),
                ('streetAddress',
                 models.CharField(blank=True, max_length=255, null=True)),
                ('municipality',
                 models.CharField(blank=True, max_length=255, null=True)),
                ('province',
                 models.CharField(blank=True, max_length=255, null=True)),
                ('postalCode',
                 models.CharField(blank=True, max_length=255, null=True)),
                ('latLong',
                 models.CharField(blank=True, max_length=255, null=True)),
                ('effectiveDate',
                 models.DateField(default=django.utils.timezone.now)),
                ('endDate', models.DateField(blank=True, null=True)),
                ('doingBusinessAsId',
                 models.ForeignKey(blank=True,
                                   null=True,
                                   on_delete=django.db.models.deletion.CASCADE,
                                   related_name='locations',
                                   to='api_v2.DoingBusinessAs')),
            ],
            options={
                'db_table': 'LOCATION',
            },
        ),
        migrations.CreateModel(
            name='LocationType',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('create_timestamp',
                 models.DateTimeField(auto_now_add=True, null=True)),
                ('update_timestamp',
                 models.DateTimeField(auto_now=True, null=True)),
                ('locType', models.CharField(max_length=255)),
                ('description', models.CharField(max_length=255)),
                ('effectiveDate',
                 models.DateField(default=django.utils.timezone.now)),
                ('endDate', models.DateField(blank=True, null=True)),
                ('displayOrder', models.IntegerField()),
            ],
            options={
                'db_table': 'LOCATION_TYPE',
            },
        ),
        migrations.CreateModel(
            name='VerifiableClaim',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('create_timestamp',
                 models.DateTimeField(auto_now_add=True, null=True)),
                ('update_timestamp',
                 models.DateTimeField(auto_now=True, null=True)),
                ('claimJSON', models.TextField(blank=True, null=True)),
                ('effectiveDate',
                 models.DateField(default=django.utils.timezone.now)),
                ('endDate', models.DateField(blank=True, null=True)),
            ],
            options={
                'db_table': 'VERIFIABLE_CLAIM',
            },
        ),
        migrations.CreateModel(
            name='VerifiableClaimType',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('create_timestamp',
                 models.DateTimeField(auto_now_add=True, null=True)),
                ('update_timestamp',
                 models.DateTimeField(auto_now=True, null=True)),
                ('claimType', models.CharField(max_length=255)),
                ('base64Logo',
                 models.CharField(blank=True, max_length=255, null=True)),
                ('issuerURL', models.CharField(max_length=255)),
                ('effectiveDate',
                 models.DateField(default=django.utils.timezone.now)),
                ('schemaName',
                 models.CharField(blank=True, max_length=255, null=True)),
                ('schemaVersion',
                 models.CharField(blank=True, max_length=255, null=True)),
                ('endDate', models.DateField(blank=True, null=True)),
                ('issuerServiceId',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   related_name='issuerServices',
                                   to='api_v2.IssuerService')),
            ],
            options={
                'db_table': 'VERIFIABLE_CLAIM_TYPE',
            },
        ),
        migrations.CreateModel(
            name='VerifiableOrg',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('create_timestamp',
                 models.DateTimeField(auto_now_add=True, null=True)),
                ('update_timestamp',
                 models.DateTimeField(auto_now=True, null=True)),
                ('orgId', models.CharField(max_length=255)),
                ('legalName', models.CharField(max_length=255)),
                ('effectiveDate',
                 models.DateField(default=django.utils.timezone.now)),
                ('endDate', models.DateField(blank=True, null=True)),
                ('jurisdictionId',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   related_name='verifiableOrgJurisdictions',
                                   to='api_v2.Jurisdiction')),
            ],
            options={
                'db_table': 'VERIFIABLE_ORG',
            },
        ),
        migrations.CreateModel(
            name='VerifiableOrgType',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('create_timestamp',
                 models.DateTimeField(auto_now_add=True, null=True)),
                ('update_timestamp',
                 models.DateTimeField(auto_now=True, null=True)),
                ('orgType',
                 models.CharField(blank=True, max_length=255, null=True)),
                ('description',
                 models.CharField(blank=True, max_length=255, null=True)),
                ('effectiveDate',
                 models.DateField(default=django.utils.timezone.now)),
                ('endDate', models.DateField(blank=True, null=True)),
                ('displayOrder', models.IntegerField()),
            ],
            options={
                'db_table': 'VERIFIABLE_ORG_TYPE',
            },
        ),
        migrations.AddField(
            model_name='verifiableorg',
            name='orgTypeId',
            field=models.ForeignKey(
                default=1,
                on_delete=django.db.models.deletion.CASCADE,
                related_name='verifiableOrgTypes',
                to='api_v2.VerifiableOrgType'),
        ),
        migrations.AddField(
            model_name='verifiableclaim',
            name='claimType',
            field=models.ForeignKey(
                on_delete=django.db.models.deletion.CASCADE,
                related_name='claimTypes',
                to='api_v2.VerifiableClaimType'),
        ),
        migrations.AddField(
            model_name='verifiableclaim',
            name='inactiveClaimReasonId',
            field=models.ForeignKey(
                blank=True,
                null=True,
                on_delete=django.db.models.deletion.CASCADE,
                related_name='inactiveClaimReasons',
                to='api_v2.InactiveClaimReason'),
        ),
        migrations.AddField(
            model_name='verifiableclaim',
            name='verifiableOrgId',
            field=models.ForeignKey(
                on_delete=django.db.models.deletion.CASCADE,
                related_name='claims',
                to='api_v2.VerifiableOrg'),
        ),
        migrations.AddField(
            model_name='location',
            name='locationTypeId',
            field=models.ForeignKey(
                on_delete=django.db.models.deletion.CASCADE,
                related_name='locationTypes',
                to='api_v2.LocationType'),
        ),
        migrations.AddField(
            model_name='location',
            name='verifiableOrgId',
            field=models.ForeignKey(
                default=0,
                on_delete=django.db.models.deletion.CASCADE,
                related_name='locations',
                to='api_v2.VerifiableOrg'),
        ),
        migrations.AddField(
            model_name='issuerservice',
            name='jurisdictionId',
            field=models.ForeignKey(
                on_delete=django.db.models.deletion.CASCADE,
                related_name='issuerServiceJurisdictions',
                to='api_v2.Jurisdiction'),
        ),
        migrations.AddField(
            model_name='doingbusinessas',
            name='verifiableOrgId',
            field=models.ForeignKey(
                blank=True,
                null=True,
                on_delete=django.db.models.deletion.CASCADE,
                related_name='doingBusinessAs',
                to='api_v2.VerifiableOrg'),
        ),
    ]
Ejemplo n.º 21
0
class Migration(migrations.Migration):

    initial = True

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

    operations = [
        migrations.CreateModel(
            name='UserProfile',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('password',
                 models.CharField(max_length=128, verbose_name='password')),
                ('last_login',
                 models.DateTimeField(blank=True,
                                      null=True,
                                      verbose_name='last login')),
                ('is_superuser',
                 models.BooleanField(
                     default=False,
                     help_text=
                     'Designates that this user has all permissions without explicitly assigning them.',
                     verbose_name='superuser status')),
                ('username',
                 models.CharField(
                     error_messages={
                         'unique': 'A user with that username already exists.'
                     },
                     help_text=
                     'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.',
                     max_length=150,
                     unique=True,
                     validators=[
                         django.contrib.auth.validators.
                         UnicodeUsernameValidator()
                     ],
                     verbose_name='username')),
                ('first_name',
                 models.CharField(blank=True,
                                  max_length=30,
                                  verbose_name='first name')),
                ('last_name',
                 models.CharField(blank=True,
                                  max_length=150,
                                  verbose_name='last name')),
                ('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')),
                ('fullname', models.CharField(max_length=10,
                                              verbose_name='姓名')),
                ('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={
                'verbose_name': '用户',
                'verbose_name_plural': '用户',
            },
            managers=[
                ('objects', django.contrib.auth.models.UserManager()),
            ],
        ),
        migrations.CreateModel(
            name='Account',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('code', models.CharField(max_length=10, verbose_name='科目代码')),
                ('name', models.CharField(max_length=20, verbose_name='科目名称')),
            ],
            options={
                'ordering': ['code'],
            },
        ),
        migrations.CreateModel(
            name='Certificate',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('bookedDate', models.DateField(verbose_name='记账日期')),
                ('sn', models.CharField(max_length=15, verbose_name='流水号')),
                ('amount',
                 models.DecimalField(decimal_places=2,
                                     max_digits=10,
                                     verbose_name='金额')),
                ('attachmentNo',
                 models.PositiveSmallIntegerField(verbose_name='附件张数')),
                ('accountDetail',
                 models.CharField(blank=True,
                                  max_length=50,
                                  null=True,
                                  verbose_name='科目明细')),
                ('uploaderName',
                 models.CharField(max_length=10, verbose_name='录入人')),
                ('submitted',
                 models.BooleanField(default=False, verbose_name='是否提交')),
                ('confirmed',
                 models.BooleanField(default=False, verbose_name='是否确认')),
                ('account',
                 models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
                                   to='imgs.Account')),
            ],
            options={
                'ordering': ['-bookedDate', '-sn'],
            },
        ),
        migrations.CreateModel(
            name='CertificateImg',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('uploadTime',
                 models.DateTimeField(auto_now=True, verbose_name='上传时间')),
                ('img', models.BinaryField(verbose_name='图像数据')),
                ('thumb', models.BinaryField(verbose_name='缩略图')),
                ('certificate',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to='imgs.Certificate')),
            ],
            options={
                'ordering': ['uploadTime'],
            },
        ),
        migrations.CreateModel(
            name='Menu',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('text', models.CharField(max_length=20, verbose_name='菜单名称')),
                ('iconCls', models.CharField(max_length=50,
                                             verbose_name='图标样式')),
                ('checked', models.NullBooleanField(verbose_name='是否选中')),
                ('url',
                 models.CharField(blank=True,
                                  max_length=300,
                                  null=True,
                                  verbose_name='链接')),
                ('seq', models.PositiveSmallIntegerField(verbose_name='顺序')),
                ('parentMenu',
                 models.ForeignKey(blank=True,
                                   null=True,
                                   on_delete=django.db.models.deletion.PROTECT,
                                   related_name='children',
                                   to='imgs.Menu')),
            ],
            options={
                'ordering': ['seq'],
            },
        ),
        migrations.CreateModel(
            name='Org',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('code',
                 models.CharField(max_length=10,
                                  unique=True,
                                  verbose_name='机构代码')),
                ('name', models.CharField(max_length=20, verbose_name='机构名称')),
                ('seq', models.PositiveSmallIntegerField(verbose_name='顺序')),
            ],
            options={
                'ordering': ['seq'],
            },
        ),
        migrations.AddField(
            model_name='certificate',
            name='org',
            field=models.ForeignKey(
                default=1,
                on_delete=django.db.models.deletion.PROTECT,
                to='imgs.Org'),
        ),
        migrations.AddField(
            model_name='userprofile',
            name='org',
            field=models.ForeignKey(
                null=True,
                on_delete=django.db.models.deletion.PROTECT,
                to='imgs.Org',
                verbose_name='所属机构'),
        ),
        migrations.AddField(
            model_name='userprofile',
            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'),
        ),
    ]
Ejemplo n.º 22
0
class Migration(migrations.Migration):

    initial = True

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

    operations = [
        migrations.CreateModel(
            name="User",
            fields=[
                (
                    "id",
                    models.AutoField(
                        auto_created=True,
                        primary_key=True,
                        serialize=False,
                        verbose_name="ID",
                    ),
                ),
                ("password",
                 models.CharField(max_length=128, verbose_name="password")),
                (
                    "last_login",
                    models.DateTimeField(blank=True,
                                         null=True,
                                         verbose_name="last login"),
                ),
                (
                    "is_superuser",
                    models.BooleanField(
                        default=False,
                        help_text=
                        "Designates that this user has all permissions without explicitly assigning them.",
                        verbose_name="superuser status",
                    ),
                ),
                (
                    "username",
                    models.CharField(
                        error_messages={
                            "unique":
                            "A user with that username already exists."
                        },
                        help_text=
                        "Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.",
                        max_length=150,
                        unique=True,
                        validators=[
                            django.contrib.auth.validators.
                            ASCIIUsernameValidator()
                        ],
                        verbose_name="username",
                    ),
                ),
                (
                    "first_name",
                    models.CharField(blank=True,
                                     max_length=30,
                                     verbose_name="first name"),
                ),
                (
                    "last_name",
                    models.CharField(blank=True,
                                     max_length=30,
                                     verbose_name="last name"),
                ),
                (
                    "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"),
                ),
                ("display_name", models.CharField(max_length=50)),
                (
                    "key",
                    models.CharField(
                        db_index=True,
                        default=credocommon.helpers.generate_token,
                        max_length=255,
                        unique=True,
                    ),
                ),
                ("email", models.EmailField(max_length=254, unique=True)),
                (
                    "email_confirmation_token",
                    models.CharField(blank=True, max_length=255),
                ),
                ("language", models.CharField(default="en", max_length=10)),
                (
                    "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,
                "verbose_name": "user",
                "verbose_name_plural": "users",
            },
            managers=[("objects", django.contrib.auth.models.UserManager())],
        ),
        migrations.CreateModel(
            name="Detection",
            fields=[
                (
                    "id",
                    models.AutoField(
                        auto_created=True,
                        primary_key=True,
                        serialize=False,
                        verbose_name="ID",
                    ),
                ),
                ("accuracy", models.FloatField()),
                ("altitude", models.FloatField()),
                ("frame_content", models.BinaryField(blank=True, null=True)),
                ("height", models.IntegerField()),
                ("width", models.IntegerField()),
                ("d_id", models.IntegerField()),
                ("latitude", models.FloatField()),
                ("longitude", models.FloatField()),
                ("provider", models.CharField(max_length=24)),
                ("timestamp", models.BigIntegerField(db_index=True)),
                ("time_received", models.BigIntegerField()),
                ("source",
                 models.CharField(default="unspecified", max_length=50)),
                ("visible", models.BooleanField(default=True)),
            ],
        ),
        migrations.CreateModel(
            name="Device",
            fields=[
                (
                    "id",
                    models.AutoField(
                        auto_created=True,
                        primary_key=True,
                        serialize=False,
                        verbose_name="ID",
                    ),
                ),
                ("device_id", models.CharField(max_length=255)),
                (
                    "device_type",
                    models.CharField(default="phone_android", max_length=255),
                ),
                ("device_model", models.CharField(max_length=255)),
                ("system_version", models.CharField(max_length=255)),
                (
                    "user",
                    models.ForeignKey(
                        on_delete=django.db.models.deletion.CASCADE,
                        to=settings.AUTH_USER_MODEL,
                    ),
                ),
            ],
        ),
        migrations.CreateModel(
            name="Ping",
            fields=[
                (
                    "id",
                    models.AutoField(
                        auto_created=True,
                        primary_key=True,
                        serialize=False,
                        verbose_name="ID",
                    ),
                ),
                ("timestamp", models.BigIntegerField(db_index=True)),
                ("delta_time", models.IntegerField(blank=True, null=True)),
                (
                    "device",
                    models.ForeignKey(
                        on_delete=django.db.models.deletion.CASCADE,
                        to="credocommon.Device",
                    ),
                ),
                (
                    "user",
                    models.ForeignKey(
                        on_delete=django.db.models.deletion.CASCADE,
                        to=settings.AUTH_USER_MODEL,
                    ),
                ),
            ],
        ),
        migrations.CreateModel(
            name="Team",
            fields=[
                (
                    "id",
                    models.AutoField(
                        auto_created=True,
                        primary_key=True,
                        serialize=False,
                        verbose_name="ID",
                    ),
                ),
                ("name", models.CharField(max_length=255, unique=True)),
            ],
        ),
        migrations.AddField(
            model_name="detection",
            name="device",
            field=models.ForeignKey(
                on_delete=django.db.models.deletion.CASCADE,
                to="credocommon.Device"),
        ),
        migrations.AddField(
            model_name="detection",
            name="team",
            field=models.ForeignKey(
                on_delete=django.db.models.deletion.CASCADE,
                to="credocommon.Team"),
        ),
        migrations.AddField(
            model_name="detection",
            name="user",
            field=models.ForeignKey(
                on_delete=django.db.models.deletion.CASCADE,
                to=settings.AUTH_USER_MODEL),
        ),
        migrations.AddField(
            model_name="user",
            name="team",
            field=models.ForeignKey(
                on_delete=django.db.models.deletion.CASCADE,
                to="credocommon.Team"),
        ),
        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",
            ),
        ),
    ]
Ejemplo n.º 23
0
class Migration(migrations.Migration):

    initial = True

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

    operations = [
        migrations.CreateModel(
            name='OdaUser',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('password',
                 models.CharField(max_length=128, verbose_name='password')),
                ('last_login',
                 models.DateTimeField(blank=True,
                                      null=True,
                                      verbose_name='last login')),
                ('is_superuser',
                 models.BooleanField(
                     default=False,
                     help_text=
                     'Designates that this user has all permissions without explicitly assigning them.',
                     verbose_name='superuser status')),
                ('username',
                 models.CharField(
                     error_messages={
                         'unique': 'A user with that username already exists.'
                     },
                     help_text=
                     'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.',
                     max_length=150,
                     unique=True,
                     validators=[
                         django.contrib.auth.validators.ASCIIUsernameValidator(
                         )
                     ],
                     verbose_name='username')),
                ('first_name',
                 models.CharField(blank=True,
                                  max_length=30,
                                  verbose_name='first name')),
                ('last_name',
                 models.CharField(blank=True,
                                  max_length=30,
                                  verbose_name='last name')),
                ('email',
                 models.EmailField(blank=True,
                                   max_length=254,
                                   verbose_name='email address')),
                ('is_staff',
                 models.BooleanField(
                     default=False,
                     help_text=
                     'Designates whether the user can log into this admin site.',
                     verbose_name='staff status')),
                ('is_active',
                 models.BooleanField(
                     default=True,
                     help_text=
                     'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.',
                     verbose_name='active')),
                ('date_joined',
                 models.DateTimeField(default=django.utils.timezone.now,
                                      verbose_name='date joined')),
                ('groups',
                 models.ManyToManyField(
                     blank=True,
                     help_text=
                     'The groups this user belongs to. A user will get all permissions granted to each of their groups.',
                     related_name='user_set',
                     related_query_name='user',
                     to='auth.Group',
                     verbose_name='groups')),
                ('user_permissions',
                 models.ManyToManyField(
                     blank=True,
                     help_text='Specific permissions for this user.',
                     related_name='user_set',
                     related_query_name='user',
                     to='auth.Permission',
                     verbose_name='user permissions')),
            ],
            options={
                'abstract': False,
                'verbose_name': 'user',
                'verbose_name_plural': 'users',
            },
            managers=[
                ('objects', django.contrib.auth.models.UserManager()),
            ],
        ),
        migrations.CreateModel(
            name='BinaryFile',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('the_file', models.FileField(upload_to=b'uploads')),
                ('filename', models.CharField(max_length=255)),
                ('filesize', models.IntegerField()),
                ('hash', models.CharField(max_length=128)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
            ],
        ),
        migrations.CreateModel(
            name='BinaryOptions',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('target', models.CharField(max_length=128)),
                ('architecture', models.CharField(max_length=128)),
                ('extra_options',
                 models.CharField(default=b'{"flags" : [] }', max_length=256)),
                ('base_address', models.CharField(max_length=18)),
            ],
        ),
        migrations.CreateModel(
            name='BinaryStringStorage',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('binary_string', models.TextField()),
                ('binary_options',
                 models.OneToOneField(
                     on_delete=django.db.models.deletion.CASCADE,
                     to='odaweb.BinaryOptions')),
            ],
        ),
        migrations.CreateModel(
            name='InstDoc',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('platform', models.TextField()),
                ('mnemonic', models.TextField()),
                ('short', models.TextField()),
                ('long', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='OdaMaster',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('ipAddress', models.CharField(default=b'', max_length=64)),
                ('project_name', models.CharField(default=b'', max_length=64)),
                ('short_name', models.CharField(db_index=True, max_length=12)),
                ('revision', models.IntegerField(default=0)),
                ('creation_date', models.DateTimeField(auto_now_add=True)),
                ('copy',
                 models.ForeignKey(null=True,
                                   on_delete=django.db.models.deletion.CASCADE,
                                   to='odaweb.OdaMaster')),
            ],
        ),
        migrations.CreateModel(
            name='OdbFileStorage',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('pickled_odb_file', models.BinaryField(null=True)),
                ('binary_file',
                 models.ForeignKey(null=True,
                                   on_delete=django.db.models.deletion.CASCADE,
                                   to='odaweb.BinaryFile')),
                ('binary_string',
                 models.ForeignKey(null=True,
                                   on_delete=django.db.models.deletion.CASCADE,
                                   to='odaweb.BinaryStringStorage')),
            ],
        ),
        migrations.CreateModel(
            name='SandboxJob',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('task_id', models.IntegerField()),
                ('reloaded', models.BooleanField(default=False)),
            ],
        ),
        migrations.CreateModel(
            name='SandboxServer',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('ip', models.CharField(max_length=255)),
                ('port', models.IntegerField()),
            ],
        ),
        migrations.CreateModel(
            name='Share',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('name', models.CharField(db_index=True, max_length=16)),
                ('odaMaster',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to='odaweb.OdaMaster')),
            ],
        ),
        migrations.AddField(
            model_name='sandboxjob',
            name='server',
            field=models.ForeignKey(
                null=True,
                on_delete=django.db.models.deletion.CASCADE,
                to='odaweb.SandboxServer'),
        ),
        migrations.AddField(
            model_name='odamaster',
            name='odb_file_storage',
            field=models.ForeignKey(
                null=True,
                on_delete=django.db.models.deletion.CASCADE,
                to='odaweb.OdbFileStorage'),
        ),
        migrations.AddField(
            model_name='odamaster',
            name='owner',
            field=models.ForeignKey(
                null=True,
                on_delete=django.db.models.deletion.CASCADE,
                to=settings.AUTH_USER_MODEL),
        ),
        migrations.AddField(
            model_name='odamaster',
            name='sandbox_job',
            field=models.ForeignKey(
                null=True,
                on_delete=django.db.models.deletion.CASCADE,
                to='odaweb.SandboxJob'),
        ),
        migrations.AddField(
            model_name='binaryfile',
            name='binary_options',
            field=models.OneToOneField(
                null=True,
                on_delete=django.db.models.deletion.CASCADE,
                to='odaweb.BinaryOptions'),
        ),
    ]
Ejemplo n.º 24
0
class Migration(migrations.Migration):

    dependencies = [
        ("auth", "0012_alter_user_first_name_max_length"),
        ("contenttypes", "0002_remove_content_type_name"),
    ]

    operations = [
        migrations.CreateModel(
            name="User",
            fields=[
                (
                    "id",
                    models.AutoField(
                        auto_created=True,
                        primary_key=True,
                        serialize=False,
                        verbose_name="ID",
                    ),
                ),
                ("password",
                 models.CharField(max_length=128, verbose_name="password")),
                (
                    "last_login",
                    models.DateTimeField(blank=True,
                                         null=True,
                                         verbose_name="last login"),
                ),
                (
                    "is_superuser",
                    models.BooleanField(
                        default=False,
                        help_text=
                        "Designates that this user has all permissions without explicitly assigning them.",
                        verbose_name="superuser status",
                    ),
                ),
                (
                    "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"),
                ),
                (
                    "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"),
                ),
                (
                    "username",
                    models.CharField(
                        db_index=True,
                        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",
                    ),
                ),
                (
                    "groups",
                    models.ManyToManyField(
                        blank=True,
                        help_text=
                        "The groups this user belongs to. A user will get all permissions granted to each of their groups.",
                        related_name="user_set",
                        related_query_name="user",
                        to="auth.Group",
                        verbose_name="groups",
                    ),
                ),
                (
                    "user_permissions",
                    models.ManyToManyField(
                        blank=True,
                        help_text="Specific permissions for this user.",
                        related_name="user_set",
                        related_query_name="user",
                        to="auth.Permission",
                        verbose_name="user permissions",
                    ),
                ),
            ],
            options={
                "abstract": False,
            },
        ),
        migrations.CreateModel(
            name="DBFile",
            fields=[
                (
                    "id",
                    models.AutoField(
                        auto_created=True,
                        primary_key=True,
                        serialize=False,
                        verbose_name="ID",
                    ),
                ),
                ("name",
                 models.CharField(db_index=True, max_length=100, unique=True)),
                ("content", models.BinaryField()),
                ("md5", models.CharField(db_index=True, max_length=32)),
                ("size", models.PositiveIntegerField(default=0)),
                (
                    "suggested_name",
                    models.CharField(blank=True, default="", max_length=100),
                ),
                ("object_id",
                 models.PositiveIntegerField(db_index=True, null=True)),
                (
                    "content_type",
                    models.ForeignKey(
                        null=True,
                        on_delete=django.db.models.deletion.CASCADE,
                        to="contenttypes.contenttype",
                    ),
                ),
            ],
            options={
                "index_together": {("object_id", "content_type")},
            },
        ),
        migrations.AlterModelManagers(
            name="user",
            managers=[
                ("objects", django.contrib.auth.models.UserManager()),
            ],
        ),
        migrations.AlterField(
            model_name="user",
            name="username",
            field=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",
            ),
        ),
    ]
Ejemplo n.º 25
0
class Migration(migrations.Migration):

    initial = True

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

    operations = [
        migrations.CreateModel(
            name='User',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('password',
                 models.CharField(max_length=128, verbose_name='password')),
                ('last_login',
                 models.DateTimeField(blank=True,
                                      null=True,
                                      verbose_name='last login')),
                ('is_superuser',
                 models.BooleanField(
                     default=False,
                     help_text=
                     'Designates that this user has all permissions without explicitly assigning them.',
                     verbose_name='superuser status')),
                ('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')),
                ('is_premium', models.BooleanField(default=False)),
                ('groups',
                 models.ManyToManyField(
                     blank=True,
                     help_text=
                     'The groups this user belongs to. A user will get all permissions granted to each of their groups.',
                     related_name='user_set',
                     related_query_name='user',
                     to='auth.Group',
                     verbose_name='groups')),
                ('user_permissions',
                 models.ManyToManyField(
                     blank=True,
                     help_text='Specific permissions for this user.',
                     related_name='user_set',
                     related_query_name='user',
                     to='auth.Permission',
                     verbose_name='user permissions')),
            ],
            options={
                'verbose_name': 'user',
                'verbose_name_plural': 'users',
                'abstract': False,
            },
            managers=[
                ('objects', django.contrib.auth.models.UserManager()),
            ],
        ),
        migrations.CreateModel(
            name='Person',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('name', models.CharField(max_length=1024)),
                ('photo_encoding', models.BinaryField()),
            ],
        ),
        migrations.CreateModel(
            name='SearchResult',
            fields=[
                ('id',
                 models.AutoField(auto_created=True,
                                  primary_key=True,
                                  serialize=False,
                                  verbose_name='ID')),
                ('answer',
                 models.TextField(
                     max_length=100,
                     verbose_name='Initials of the person in the image')),
                ('uploaded_image', models.ImageField(upload_to='photos/')),
                ('upload_date', models.DateTimeField(auto_now_add=True)),
                ('uploaded_by',
                 models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
                                   to=settings.AUTH_USER_MODEL)),
            ],
        ),
    ]
Ejemplo n.º 26
0
class Migration(migrations.Migration):

    initial = True

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

    operations = [
        migrations.CreateModel(
            name='Activity',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('type', models.CharField(choices=[('HW', 'Homework'), ('QZ', 'Quiz'), ('NT', 'Notification')], max_length=2)),
                ('title', models.TextField()),
                ('content', models.TextField()),
                ('create_date', models.DateTimeField(auto_now=True)),
                ('due_date', models.DateTimeField()),
            ],
        ),
        migrations.CreateModel(
            name='Class',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('class_name', models.CharField(max_length=200)),
                ('create_date', models.DateTimeField(auto_now=True)),
                ('info', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='Discuss',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('title', models.CharField(max_length=200)),
                ('create_time', models.DateTimeField(auto_now=True)),
            ],
        ),
        migrations.CreateModel(
            name='File',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('url', models.CharField(max_length=200)),
            ],
        ),
        migrations.CreateModel(
            name='Group',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('class_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='db.Class')),
            ],
        ),
        migrations.CreateModel(
            name='Problem',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('question', models.TextField()),
                ('type', models.CharField(choices=[('CH', 'Choice'), ('BK', 'Blank'), ('TX', 'Text'), ('FL', 'File')], max_length=2)),
                ('key', models.CharField(max_length=50)),
            ],
        ),
        migrations.CreateModel(
            name='Section',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('number', models.CharField(max_length=50)),
                ('name', models.CharField(max_length=50)),
                ('class_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='db.Class')),
            ],
        ),
        migrations.CreateModel(
            name='Submit',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('key', models.TextField()),
                ('file', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='db.File')),
                ('problem', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='db.Problem')),
            ],
        ),
        migrations.CreateModel(
            name='User',
            fields=[
                ('user_ptr', models.OneToOneField(auto_created=True, on_delete=django.db.models.deletion.CASCADE, parent_link=True, primary_key=True, serialize=False, to=settings.AUTH_USER_MODEL)),
                ('info', models.TextField()),
            ],
            options={
                'verbose_name_plural': 'users',
                'abstract': False,
                'verbose_name': 'user',
            },
            bases=('auth.user',),
            managers=[
                ('objects', django.contrib.auth.models.UserManager()),
            ],
        ),
        migrations.CreateModel(
            name='Admin',
            fields=[
                ('id', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to='db.User')),
                ('role', models.CharField(max_length=50)),
            ],
        ),
        migrations.CreateModel(
            name='Student',
            fields=[
                ('id', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to='db.User')),
                ('student_id', models.CharField(max_length=50)),
                ('dept', models.CharField(max_length=50)),
            ],
        ),
        migrations.CreateModel(
            name='TA',
            fields=[
                ('id', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to='db.User')),
                ('ta_id', models.CharField(max_length=50)),
                ('dept', models.CharField(max_length=50)),
                ('authority', models.BinaryField()),
            ],
        ),
        migrations.CreateModel(
            name='Teacher',
            fields=[
                ('id', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to='db.User')),
                ('teacher_id', models.CharField(max_length=50)),
                ('dept', models.CharField(max_length=50)),
            ],
        ),
        migrations.CreateModel(
            name='SubmitScore',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('score', models.CharField(max_length=10)),
                ('time', models.DateTimeField(auto_now=True)),
                ('rater', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='db.User')),
                ('submit', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='db.Submit')),
            ],
        ),
        migrations.CreateModel(
            name='SectionHasFile',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('file', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='db.File')),
                ('section', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='db.Section')),
            ],
        ),
        migrations.AddField(
            model_name='section',
            name='files',
            field=models.ManyToManyField(through='db.SectionHasFile', to='db.File'),
        ),
        migrations.AddField(
            model_name='section',
            name='subsection',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='db.Section'),
        ),
        migrations.CreateModel(
            name='Post',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('content', models.TextField()),
                ('create_time', models.DateTimeField(auto_now=True)),
                ('author', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='db.User')),
                ('discuss', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='db.Discuss')),
                ('reply', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='db.Post')),
            ],
        ),
        migrations.AddField(
            model_name='file',
            name='uploader',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='db.User'),
        ),
        migrations.AddField(
            model_name='discuss',
            name='author',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='db.User'),
        ),
        migrations.AddField(
            model_name='discuss',
            name='class_id',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='db.Class'),
        ),
        migrations.CreateModel(
            name='ActivityHasProblem',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('activity', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='db.Activity')),
                ('problem', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='db.Problem')),
            ],
        ),
        migrations.CreateModel(
            name='ActivityHasFile',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('activity', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='db.Activity')),
                ('file', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='db.File')),
            ],
        ),
        migrations.AddField(
            model_name='activity',
            name='author',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='db.User'),
        ),
        migrations.AddField(
            model_name='activity',
            name='class_id',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='db.Class'),
        ),
        migrations.AddField(
            model_name='activity',
            name='files',
            field=models.ManyToManyField(through='db.ActivityHasFile', to='db.File'),
        ),
        migrations.AddField(
            model_name='activity',
            name='problems',
            field=models.ManyToManyField(through='db.ActivityHasProblem', to='db.Problem'),
        ),
        migrations.CreateModel(
            name='TeachMembership',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('create_time', models.DateTimeField(auto_now=True)),
                ('class_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='db.Class')),
                ('teacher', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='db.Teacher')),
            ],
        ),
        migrations.CreateModel(
            name='TAMembership',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('create_time', models.DateTimeField(auto_now=True)),
                ('class_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='db.Class')),
                ('ta', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='db.TA')),
            ],
        ),
        migrations.AddField(
            model_name='submit',
            name='student',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='db.Student'),
        ),
        migrations.CreateModel(
            name='StudentMembership',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('create_time', models.DateTimeField(auto_now=True)),
                ('class_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='db.Class')),
                ('student', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='db.Student')),
            ],
        ),
        migrations.CreateModel(
            name='GroupMembership',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('create_time', models.DateTimeField(auto_now=True)),
                ('group', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='db.Group')),
                ('student', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='db.Student')),
            ],
        ),
        migrations.AddField(
            model_name='group',
            name='members',
            field=models.ManyToManyField(through='db.GroupMembership', to='db.Student'),
        ),
        migrations.AddField(
            model_name='class',
            name='students',
            field=models.ManyToManyField(through='db.StudentMembership', to='db.Student'),
        ),
        migrations.AddField(
            model_name='class',
            name='tas',
            field=models.ManyToManyField(through='db.TAMembership', to='db.TA'),
        ),
        migrations.AddField(
            model_name='class',
            name='teachers',
            field=models.ManyToManyField(through='db.TeachMembership', to='db.Teacher'),
        ),
        migrations.AddConstraint(
            model_name='activity',
            constraint=models.CheckConstraint(check=models.Q(due_date__gt=django.db.models.expressions.F('create_date')), name='check_due_time'),
        ),
    ]
Ejemplo n.º 27
0
class Migration(migrations.Migration):

    initial = True

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

    operations = [
        migrations.CreateModel(
            name='User',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('password', models.CharField(max_length=128, verbose_name='password')),
                ('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')),
                ('is_superuser', models.BooleanField(default=False, help_text='Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')),
                ('username', models.CharField(error_messages={'unique': 'A user with that username already exists.'}, help_text='Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, validators=[django.contrib.auth.validators.UnicodeUsernameValidator()], verbose_name='username')),
                ('first_name', models.CharField(blank=True, max_length=30, verbose_name='first name')),
                ('last_name', models.CharField(blank=True, max_length=150, verbose_name='last name')),
                ('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')),
                ('groups', models.ManyToManyField(blank=True, help_text='The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups')),
                ('user_permissions', models.ManyToManyField(blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions')),
            ],
            options={
                'abstract': False,
                'verbose_name': 'user',
                'verbose_name_plural': 'users',
            },
            managers=[
                ('objects', django.contrib.auth.models.UserManager()),
            ],
        ),
        migrations.CreateModel(
            name='Job',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('job_id', models.UUIDField(default=uuid.uuid4, editable=False, unique=True)),
                ('seller_ids', models.TextField(blank=True, default=None, max_length=20000, null=True, verbose_name='Seller Ids')),
                ('asin_codes', models.TextField(blank=True, default=None, max_length=20000, null=True, verbose_name='Asin Codes')),
                ('scout_file', models.BinaryField(blank=True, default=None, null=True, verbose_name='Scout File')),
                ('asin_file', models.BinaryField(blank=True, default=None, null=True, verbose_name='ASIN File')),
                ('scout_status', models.BooleanField(default=False, verbose_name='Scout Status')),
                ('asin_status', models.BooleanField(default=False, verbose_name='ASIN Search Status')),
                ('scout_results_counter', models.IntegerField(blank=True, default=0, null=True, verbose_name='Scout Results Count')),
                ('asin_results_counter', models.IntegerField(blank=True, default=0, null=True, verbose_name='ASIN Results Count')),
                ('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.CreateModel(
            name='Product',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('ebay_title', models.CharField(blank=True, default=None, max_length=2000, null=True, verbose_name='Ebay Product Title')),
                ('ebay_url', models.CharField(blank=True, default=None, max_length=2000, null=True, verbose_name='Ebay Product Url')),
                ('ebay_sold_quantity', models.CharField(blank=True, default=None, max_length=2000, null=True, verbose_name='Ebay Product Quantity Sold')),
                ('ebay_price', models.CharField(blank=True, default=None, max_length=2000, null=True, verbose_name='Ebay Product Price')),
                ('ebay_img_url', models.CharField(blank=True, default=None, max_length=2000, null=True, verbose_name='Ebay Product Image Url')),
                ('ebay_review_count', models.CharField(blank=True, default=None, max_length=2000, null=True, verbose_name='Ebay Product Review Count')),
                ('ebay_review_score', models.CharField(blank=True, default=None, max_length=2000, null=True, verbose_name='Ebay Product Review Score')),
                ('ebay_brand', models.CharField(blank=True, default=None, max_length=2000, null=True, verbose_name='Ebay Product Brand')),
                ('ebay_bread_crumbs', models.CharField(blank=True, default=None, max_length=2000, null=True, verbose_name='Ebay Product Bread Crumbs')),
                ('ebay_cat_id', models.CharField(blank=True, default=None, max_length=2000, null=True, verbose_name='Ebay Product Category Id')),
                ('ebay_upc', models.CharField(blank=True, default=None, max_length=2000, null=True, verbose_name='Ebay Product UPC')),
                ('ebay_mpn', models.CharField(blank=True, default=None, max_length=2000, null=True, verbose_name='Ebay Product MPN')),
                ('ebay_ssn', models.CharField(blank=True, default=None, max_length=2000, null=True, verbose_name='Ebay Seller SSN')),
                ('amazon_url', models.CharField(blank=True, default=None, max_length=2000, null=True, verbose_name='Amazon Product Url')),
                ('amazon_asin', models.CharField(blank=True, default=None, max_length=2000, null=True, verbose_name='Amazon Product ASIN')),
                ('amazon_is_prime', models.BooleanField(default=False, verbose_name='Amazon Is Prime?')),
                ('amazon_is_addon', models.BooleanField(default=False, verbose_name='Amazon Is Addon?')),
                ('amazon_title', models.CharField(blank=True, default=None, max_length=2000, null=True, verbose_name='Amazon Product Title')),
                ('amazon_price', models.CharField(blank=True, default=None, max_length=2000, null=True, verbose_name='Amazon Product Price')),
                ('amazon_img_url', models.CharField(blank=True, default=None, max_length=2000, null=True, verbose_name='Amazon Product Image Url')),
                ('amazon_review_count', models.CharField(blank=True, default=None, max_length=2000, null=True, verbose_name='Amazon Product Review Count')),
                ('amazon_review_score', models.CharField(blank=True, default=None, max_length=2000, null=True, verbose_name='Amazon Product Review Score')),
                ('amazon_bread_crumbs', models.CharField(blank=True, default=None, max_length=2000, null=True, verbose_name='Amazon Product Bread Crumbs')),
                ('amazon_features', models.TextField(blank=True, default=None, max_length=5000, null=True, verbose_name='Amazon Product Features')),
                ('amazon_brand', models.CharField(blank=True, default=None, max_length=2000, null=True, verbose_name='Amazon Product Brand Name')),
                ('amazon_product_images', models.TextField(blank=True, default=None, max_length=2000, null=True, verbose_name='Amazon Product Images')),
                ('amazon_description', models.TextField(blank=True, default=None, max_length=3000, null=True, verbose_name='Amazon Product Description')),
                ('amazon_weight', models.CharField(blank=True, default=None, max_length=200, null=True, verbose_name='Amazon Product Weight')),
                ('amazon_dimensions', models.CharField(blank=True, default=None, max_length=200, null=True, verbose_name='Amazon Product Dimensions')),
                ('amazon_item_model_number', models.CharField(blank=True, default=None, max_length=200, null=True, verbose_name='Amazon Product Model Number')),
                ('amazon_manufacturer', models.CharField(blank=True, default=None, max_length=200, null=True, verbose_name='Amazon Product Manufacturer')),
                ('amazon_sold_by', models.CharField(blank=True, default=None, max_length=200, null=True, verbose_name='Amazon Product Sold By')),
                ('amazon_in_stock', models.CharField(blank=True, default=None, max_length=500, null=True, verbose_name='Amazon Product In Stock')),
                ('updated_timestamp', models.DateTimeField(auto_now=True, null=True, verbose_name='Last Updated At')),
                ('created_timestamp', models.DateTimeField(auto_now_add=True, null=True, verbose_name='Created At')),
                ('job', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='scout.Job')),
            ],
        ),
        migrations.CreateModel(
            name='Proxy',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('ip', models.CharField(blank=True, default=None, max_length=200, null=True, verbose_name='Proxy Ip')),
            ],
            options={
                'verbose_name_plural': 'Proxies',
            },
        ),
    ]
Ejemplo n.º 28
0
class Migration(migrations.Migration):

    initial = True

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

    operations = [
        migrations.CreateModel(
            name="User",
            fields=[
                (
                    "id",
                    models.AutoField(
                        auto_created=True,
                        primary_key=True,
                        serialize=False,
                        verbose_name="ID",
                    ),
                ),
                ("password",
                 models.CharField(max_length=128, verbose_name="password")),
                (
                    "last_login",
                    models.DateTimeField(blank=True,
                                         null=True,
                                         verbose_name="last login"),
                ),
                (
                    "is_superuser",
                    models.BooleanField(
                        default=False,
                        help_text=
                        "Designates that this user has all permissions without explicitly assigning them.",
                        verbose_name="superuser status",
                    ),
                ),
                (
                    "username",
                    models.CharField(
                        error_messages={
                            "unique":
                            "A user with that username already exists."
                        },
                        help_text=
                        "Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.",
                        max_length=150,
                        unique=True,
                        validators=[
                            django.contrib.auth.validators.
                            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=30,
                                     verbose_name="last name"),
                ),
                (
                    "email",
                    models.EmailField(blank=True,
                                      max_length=254,
                                      verbose_name="email address"),
                ),
                (
                    "is_staff",
                    models.BooleanField(
                        default=False,
                        help_text=
                        "Designates whether the user can log into this admin site.",
                        verbose_name="staff status",
                    ),
                ),
                (
                    "is_active",
                    models.BooleanField(
                        default=True,
                        help_text=
                        "Designates whether this user should be treated as active. Unselect this instead of deleting accounts.",
                        verbose_name="active",
                    ),
                ),
                (
                    "date_joined",
                    models.DateTimeField(default=django.utils.timezone.now,
                                         verbose_name="date joined"),
                ),
                ("DID", models.TextField(blank=True,
                                         max_length=60,
                                         unique=True)),
                ("verkey", models.BinaryField(blank=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,
            },
            managers=[("objects", django.contrib.auth.models.UserManager())],
        ),
        migrations.CreateModel(
            name="DoingBusinessAs",
            fields=[
                (
                    "id",
                    models.AutoField(
                        auto_created=True,
                        primary_key=True,
                        serialize=False,
                        verbose_name="ID",
                    ),
                ),
                (
                    "create_timestamp",
                    models.DateTimeField(auto_now_add=True, null=True),
                ),
                ("update_timestamp",
                 models.DateTimeField(auto_now=True, null=True)),
                ("dbaName", models.CharField(max_length=255)),
                ("effectiveDate",
                 models.DateField(default=django.utils.timezone.now)),
                ("endDate", models.DateField(blank=True, null=True)),
            ],
            options={"db_table": "DOING_BUSINESS_AS"},
        ),
        migrations.CreateModel(
            name="InactiveClaimReason",
            fields=[
                (
                    "id",
                    models.AutoField(
                        auto_created=True,
                        primary_key=True,
                        serialize=False,
                        verbose_name="ID",
                    ),
                ),
                (
                    "create_timestamp",
                    models.DateTimeField(auto_now_add=True, null=True),
                ),
                ("update_timestamp",
                 models.DateTimeField(auto_now=True, null=True)),
                (
                    "shortReason",
                    models.CharField(blank=True, max_length=255, null=True),
                ),
                ("reason",
                 models.CharField(blank=True, max_length=255, null=True)),
                ("effectiveDate",
                 models.DateField(default=django.utils.timezone.now)),
                ("endDate", models.DateField(blank=True, null=True)),
                ("displayOrder", models.IntegerField()),
            ],
            options={"db_table": "INACTIVE_CLAIM_REASON"},
        ),
        migrations.CreateModel(
            name="IssuerService",
            fields=[
                (
                    "id",
                    models.AutoField(
                        auto_created=True,
                        primary_key=True,
                        serialize=False,
                        verbose_name="ID",
                    ),
                ),
                (
                    "create_timestamp",
                    models.DateTimeField(auto_now_add=True, null=True),
                ),
                ("update_timestamp",
                 models.DateTimeField(auto_now=True, null=True)),
                ("name", models.CharField(max_length=255)),
                ("issuerOrgTLA", models.CharField(max_length=255)),
                (
                    "issuerOrgURL",
                    models.CharField(blank=True, max_length=255, null=True),
                ),
                ("DID", models.CharField(max_length=255)),
                ("effectiveDate",
                 models.DateField(default=django.utils.timezone.now)),
                ("endDate", models.DateField(blank=True, null=True)),
            ],
            options={"db_table": "ISSUER_SERVICE"},
        ),
        migrations.CreateModel(
            name="Jurisdiction",
            fields=[
                (
                    "id",
                    models.AutoField(
                        auto_created=True,
                        primary_key=True,
                        serialize=False,
                        verbose_name="ID",
                    ),
                ),
                (
                    "create_timestamp",
                    models.DateTimeField(auto_now_add=True, null=True),
                ),
                ("update_timestamp",
                 models.DateTimeField(auto_now=True, null=True)),
                ("abbrv", models.CharField(max_length=25)),
                ("name", models.CharField(max_length=1000)),
                ("displayOrder", models.IntegerField()),
                ("isOnCommonList", models.BooleanField()),
                ("effectiveDate",
                 models.DateField(default=django.utils.timezone.now)),
                ("endDate", models.DateField(blank=True, null=True)),
            ],
            options={"db_table": "JURISDICTION"},
        ),
        migrations.CreateModel(
            name="Location",
            fields=[
                (
                    "id",
                    models.AutoField(
                        auto_created=True,
                        primary_key=True,
                        serialize=False,
                        verbose_name="ID",
                    ),
                ),
                (
                    "create_timestamp",
                    models.DateTimeField(auto_now_add=True, null=True),
                ),
                ("update_timestamp",
                 models.DateTimeField(auto_now=True, null=True)),
                ("addressee",
                 models.CharField(blank=True, max_length=255, null=True)),
                (
                    "addlDeliveryInfo",
                    models.CharField(blank=True, max_length=255, null=True),
                ),
                ("unitNumber",
                 models.CharField(blank=True, max_length=255, null=True)),
                (
                    "streetAddress",
                    models.CharField(blank=True, max_length=255, null=True),
                ),
                (
                    "municipality",
                    models.CharField(blank=True, max_length=255, null=True),
                ),
                ("province",
                 models.CharField(blank=True, max_length=255, null=True)),
                ("postalCode",
                 models.CharField(blank=True, max_length=255, null=True)),
                ("latLong",
                 models.CharField(blank=True, max_length=255, null=True)),
                ("effectiveDate",
                 models.DateField(default=django.utils.timezone.now)),
                ("endDate", models.DateField(blank=True, null=True)),
                (
                    "doingBusinessAsId",
                    models.ForeignKey(
                        blank=True,
                        null=True,
                        on_delete=django.db.models.deletion.CASCADE,
                        related_name="locations",
                        to="api_v2.DoingBusinessAs",
                    ),
                ),
            ],
            options={"db_table": "LOCATION"},
        ),
        migrations.CreateModel(
            name="LocationType",
            fields=[
                (
                    "id",
                    models.AutoField(
                        auto_created=True,
                        primary_key=True,
                        serialize=False,
                        verbose_name="ID",
                    ),
                ),
                (
                    "create_timestamp",
                    models.DateTimeField(auto_now_add=True, null=True),
                ),
                ("update_timestamp",
                 models.DateTimeField(auto_now=True, null=True)),
                ("locType", models.CharField(max_length=255)),
                ("description", models.CharField(max_length=255)),
                ("effectiveDate",
                 models.DateField(default=django.utils.timezone.now)),
                ("endDate", models.DateField(blank=True, null=True)),
                ("displayOrder", models.IntegerField()),
            ],
            options={"db_table": "LOCATION_TYPE"},
        ),
        migrations.CreateModel(
            name="VerifiableClaim",
            fields=[
                (
                    "id",
                    models.AutoField(
                        auto_created=True,
                        primary_key=True,
                        serialize=False,
                        verbose_name="ID",
                    ),
                ),
                (
                    "create_timestamp",
                    models.DateTimeField(auto_now_add=True, null=True),
                ),
                ("update_timestamp",
                 models.DateTimeField(auto_now=True, null=True)),
                ("claimJSON", models.TextField(blank=True, null=True)),
                ("effectiveDate",
                 models.DateField(default=django.utils.timezone.now)),
                ("endDate", models.DateField(blank=True, null=True)),
            ],
            options={"db_table": "VERIFIABLE_CLAIM"},
        ),
        migrations.CreateModel(
            name="VerifiableClaimType",
            fields=[
                (
                    "id",
                    models.AutoField(
                        auto_created=True,
                        primary_key=True,
                        serialize=False,
                        verbose_name="ID",
                    ),
                ),
                (
                    "create_timestamp",
                    models.DateTimeField(auto_now_add=True, null=True),
                ),
                ("update_timestamp",
                 models.DateTimeField(auto_now=True, null=True)),
                ("claimType", models.CharField(max_length=255)),
                ("base64Logo",
                 models.CharField(blank=True, max_length=255, null=True)),
                ("issuerURL", models.CharField(max_length=255)),
                ("effectiveDate",
                 models.DateField(default=django.utils.timezone.now)),
                ("schemaName",
                 models.CharField(blank=True, max_length=255, null=True)),
                (
                    "schemaVersion",
                    models.CharField(blank=True, max_length=255, null=True),
                ),
                ("endDate", models.DateField(blank=True, null=True)),
                (
                    "issuerServiceId",
                    models.ForeignKey(
                        on_delete=django.db.models.deletion.CASCADE,
                        related_name="issuerServices",
                        to="api_v2.IssuerService",
                    ),
                ),
            ],
            options={"db_table": "VERIFIABLE_CLAIM_TYPE"},
        ),
        migrations.CreateModel(
            name="VerifiableOrg",
            fields=[
                (
                    "id",
                    models.AutoField(
                        auto_created=True,
                        primary_key=True,
                        serialize=False,
                        verbose_name="ID",
                    ),
                ),
                (
                    "create_timestamp",
                    models.DateTimeField(auto_now_add=True, null=True),
                ),
                ("update_timestamp",
                 models.DateTimeField(auto_now=True, null=True)),
                ("orgId", models.CharField(max_length=255)),
                ("legalName", models.CharField(max_length=255)),
                ("effectiveDate",
                 models.DateField(default=django.utils.timezone.now)),
                ("endDate", models.DateField(blank=True, null=True)),
                (
                    "jurisdictionId",
                    models.ForeignKey(
                        on_delete=django.db.models.deletion.CASCADE,
                        related_name="verifiableOrgJurisdictions",
                        to="api_v2.Jurisdiction",
                    ),
                ),
            ],
            options={"db_table": "VERIFIABLE_ORG"},
        ),
        migrations.CreateModel(
            name="VerifiableOrgType",
            fields=[
                (
                    "id",
                    models.AutoField(
                        auto_created=True,
                        primary_key=True,
                        serialize=False,
                        verbose_name="ID",
                    ),
                ),
                (
                    "create_timestamp",
                    models.DateTimeField(auto_now_add=True, null=True),
                ),
                ("update_timestamp",
                 models.DateTimeField(auto_now=True, null=True)),
                ("orgType",
                 models.CharField(blank=True, max_length=255, null=True)),
                (
                    "description",
                    models.CharField(blank=True, max_length=255, null=True),
                ),
                ("effectiveDate",
                 models.DateField(default=django.utils.timezone.now)),
                ("endDate", models.DateField(blank=True, null=True)),
                ("displayOrder", models.IntegerField()),
            ],
            options={"db_table": "VERIFIABLE_ORG_TYPE"},
        ),
        migrations.AddField(
            model_name="verifiableorg",
            name="orgTypeId",
            field=models.ForeignKey(
                default=1,
                on_delete=django.db.models.deletion.CASCADE,
                related_name="verifiableOrgTypes",
                to="api_v2.VerifiableOrgType",
            ),
        ),
        migrations.AddField(
            model_name="verifiableclaim",
            name="claimType",
            field=models.ForeignKey(
                on_delete=django.db.models.deletion.CASCADE,
                related_name="claimTypes",
                to="api_v2.VerifiableClaimType",
            ),
        ),
        migrations.AddField(
            model_name="verifiableclaim",
            name="inactiveClaimReasonId",
            field=models.ForeignKey(
                blank=True,
                null=True,
                on_delete=django.db.models.deletion.CASCADE,
                related_name="inactiveClaimReasons",
                to="api_v2.InactiveClaimReason",
            ),
        ),
        migrations.AddField(
            model_name="verifiableclaim",
            name="verifiableOrgId",
            field=models.ForeignKey(
                on_delete=django.db.models.deletion.CASCADE,
                related_name="claims",
                to="api_v2.VerifiableOrg",
            ),
        ),
        migrations.AddField(
            model_name="location",
            name="locationTypeId",
            field=models.ForeignKey(
                on_delete=django.db.models.deletion.CASCADE,
                related_name="locationTypes",
                to="api_v2.LocationType",
            ),
        ),
        migrations.AddField(
            model_name="location",
            name="verifiableOrgId",
            field=models.ForeignKey(
                default=0,
                on_delete=django.db.models.deletion.CASCADE,
                related_name="locations",
                to="api_v2.VerifiableOrg",
            ),
        ),
        migrations.AddField(
            model_name="issuerservice",
            name="jurisdictionId",
            field=models.ForeignKey(
                on_delete=django.db.models.deletion.CASCADE,
                related_name="issuerServiceJurisdictions",
                to="api_v2.Jurisdiction",
            ),
        ),
        migrations.AddField(
            model_name="doingbusinessas",
            name="verifiableOrgId",
            field=models.ForeignKey(
                blank=True,
                null=True,
                on_delete=django.db.models.deletion.CASCADE,
                related_name="doingBusinessAs",
                to="api_v2.VerifiableOrg",
            ),
        ),
    ]