joeni

# Generated by Django 2.0b1 on 2017-11-18 22:03

import administration.models

from django.conf import settings

import django.contrib.auth.models

import django.contrib.auth.validators

import django.core.validators

from django.db import migrations, models

import django.db.models.deletion

import django.utils.timezone

import uuid

class Migration(migrations.Migration):

    initial = True

    dependencies = [

    ]

    operations = [

        migrations.CreateModel(

            name='User',

            fields=[

                ('password', models.CharField(max_length=128, verbose_name='password')),

                ('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')),

                ('is_superuser', models.BooleanField(default=False, help_text='Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')),

                ('username', models.CharField(error_messages={'unique': 'A user with that username already exists.'}, help_text='Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, validators=[django.contrib.auth.validators.UnicodeUsernameValidator()], verbose_name='username')),

                ('email', models.EmailField(blank=True, max_length=254, verbose_name='email address')),

                ('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')),

                ('number', models.PositiveIntegerField(help_text='The number assigned to this user.', primary_key=True, serialize=False)),

                ('created', models.DateField(auto_now_add=True)),

                ('passphrase', models.CharField(help_text='The passphrase used for this account. This field must only contain hashed information.', max_length=512)),

                ('first_name', models.CharField(max_length=64)),

                ('last_name', models.CharField(max_length=64)),

                ('title', models.CharField(blank=True, help_text='The academic title of this user, if applicable.', max_length=64)),

                ('DOB', models.DateField(editable=False, help_text='The date of birth of this user.')),

                ('POB', models.CharField(editable=False, help_text='The place of birth of this user.', max_length=64)),

                ('nationality', models.CharField(help_text='The current nationality of this user.', max_length=64)),

                ('national_registry_number', models.BigIntegerField(editable=False, help_text='The assigned national registry number of this user.', unique=True)),

                ('civil_status', models.CharField(choices=[('Single', 'Single'), ('Married', 'Married'), ('Divorced', 'Divorced'), ('Widowed', 'Widowed'), ('Partnership', 'Partnership')], help_text='The civil/marital status of the user.', max_length=32)),

                ('is_staff', models.BooleanField(default=False, help_text="Determines if this user is part of the university's staff.")),

                ('is_student', models.BooleanField(default=True, help_text='Indicates if this user is a student at the university.')),

                ('home_street', models.CharField(max_length=64)),

                ('home_number', models.PositiveSmallIntegerField()),

                ('home_bus', models.PositiveSmallIntegerField()),

                ('home_postal_code', models.PositiveSmallIntegerField()),

                ('home_country', models.CharField(max_length=64)),

                ('home_telephone', models.CharField(help_text='The telephone number for the house address. Prefix 0 can be presented with the national call code in the system.', max_length=64)),

                ('study_street', models.CharField(max_length=64)),

                ('study_number', models.PositiveSmallIntegerField()),

                ('study_bus', models.PositiveSmallIntegerField()),

                ('study_postal_code', models.PositiveSmallIntegerField()),

                ('study_country', models.CharField(max_length=64)),

                ('study_telephone', models.CharField(help_text='The telephone number for the study address. Prefix 0 can be presented with the national call code in the system.', max_length=64)),

                ('study_cellphone', models.CharField(help_text='The cellphone number of the person. Prefix 0 can be presented with then national call code in the system.', max_length=64)),

                ('titularis_street', models.CharField(max_length=64)),

                ('titularis_number', models.PositiveSmallIntegerField()),

                ('titularis_bus', models.PositiveSmallIntegerField()),

                ('titularis_postal_code', models.PositiveSmallIntegerField()),

                ('titularis_country', models.CharField(max_length=64)),

                ('titularis_telephone', models.CharField(help_text='The telephone number of the titularis. Prefix 0 can be presented with the national call code in the system.', max_length=64)),

                ('bank_account_number', models.CharField(help_text='The IBAN of this user. No spaces!', max_length=34, validators=[administration.models.validate_IBAN])),

                ('BIC', models.CharField(help_text="The BIC of this user's bank.", max_length=11, validators=[administration.models.validate_BIC])),

            ],

            options={

                'verbose_name': 'user',

                'verbose_name_plural': 'users',

                'abstract': False,

            },

            managers=[

                ('objects', django.contrib.auth.models.UserManager()),

            ],

        ),

        migrations.CreateModel(

            name='CourseResult',

            fields=[

                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),

                ('released', models.DateField(auto_now=True, help_text='The date that this result was last updated.')),

                ('first_score', models.PositiveSmallIntegerField(null=True, validators=[django.core.validators.MaxValueValidator(20, "The score mustn't be higher than 20.")])),

                ('second_score', models.PositiveSmallIntegerField(null=True, validators=[django.core.validators.MaxValueValidator(20, "The score mustn't be higher than 20.")])),

                ('result', models.CharField(choices=[('CRED', 'Credit acquired'), ('FAIL', 'Credit not acquired'), ('TLRD', 'Tolerated'), ('ITLD', 'Tolerance used')], help_text='The final result this record constitutes.', max_length=10)),

            ],

        ),

        migrations.CreateModel(

            name='Curriculum',

            fields=[

                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),

                ('year', models.DateField(auto_now_add=True, db_index=True, help_text='The academic year for which this curriculum is.')),

                ('last_modified', models.DateTimeField(auto_now=True, help_text='The last timestamp that this was updated.')),

                ('approved', models.NullBooleanField(default=None, help_text='Indicates if this curriculum has been approved. If true, that means the responsible committee has reviewed and approved the student for this curriculum. False otherwise. If review is still pending, the value is NULL. Modifying the curriculum implies this setting is set to NULL again.')),

                ('note', models.TextField(blank=True, help_text='Additional notes regarding this curriculum. This has multiple uses. For the student, it is used to clarify any questions, or to motivate why (s)he wants to take a course for which the requirements were not met. The reviewing committee can use this field to argument their decision, especially for when the curriculum is denied.')),

            ],

        ),

        migrations.CreateModel(

            name='Degree',

            fields=[

                ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),

                ('first_name', models.CharField(max_length=64)),

                ('last_name', models.CharField(max_length=64)),

                ('additional_names', models.CharField(max_length=64)),

                ('DOB', models.DateField(editable=False)),

                ('POB', models.CharField(editable=False, max_length=64)),

                ('study', models.CharField(editable=False, max_length=64)),

                ('achieved', models.DateField(editable=False)),

            ],

        ),

        migrations.CreateModel(

            name='PreRegistration',

            fields=[

                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),

                ('created', models.DateField(auto_now_add=True)),

                ('first_name', models.CharField(help_text='Your first name.', max_length=64)),

                ('last_name', models.CharField(help_text='Your last name.', max_length=64)),

                ('additional_names', models.CharField(blank=True, help_text='Any additional names.', max_length=64)),

                ('title', models.CharField(blank=True, help_text='Any additional titles, prefixes, ...', max_length=64)),

                ('DOB', models.DateField(editable=False, help_text='Your date of birth.')),

                ('POB', models.CharField(editable=False, help_text='The place you were born.', max_length=64)),

                ('nationality', models.CharField(help_text='Your current nationality.', max_length=64)),

                ('national_registry_number', models.BigIntegerField(help_text='If you have one, your national registry number.', null=True)),

                ('civil_status', models.CharField(choices=[('Single', 'Single'), ('Married', 'Married'), ('Divorced', 'Divorced'), ('Widowed', 'Widowed'), ('Partnership', 'Partnership')], help_text='Your civil/marital status.', max_length=32)),

                ('email', models.EmailField(help_text='The e-mail address we will use to communicate until your actual registration.', max_length=254, unique=True)),

                ('study_type', models.CharField(choices=[('Diplom contract', 'Diplom contract'), ('Exam contract', 'Exam contract'), ('Credit contract', 'Credit contract')], help_text='The type of study contract you wish to follow.', max_length=32)),

                ('document', models.FileField(help_text='Any legal documents regarding your enrollment.', upload_to='pre-enrollment/%Y')),

            ],

        ),

        migrations.CreateModel(

            name='Room',

            fields=[

                ('name', models.CharField(help_text='The name of this room. If more appropriate, this can be the colloquial name.', max_length=20, primary_key=True, serialize=False)),

                ('seats', models.PositiveSmallIntegerField(help_text='The amount of available seats in this room. This can be handy for exams for example.')),

                ('wheelchair_accessible', models.BooleanField(default=True)),

                ('exams_equipped', models.BooleanField(default=True, help_text='Indicates if exams can reasonably be held in this room.')),

                ('computers_available', models.PositiveSmallIntegerField(default=False, help_text='Indicates how many computers are available in this room.')),

                ('projector_available', models.BooleanField(default=False, help_text='Indicates if a projector is available at this room.')),

                ('blackboards_available', models.PositiveSmallIntegerField(help_text='The amount of blackboards available in this room.')),

                ('whiteboards_available', models.PositiveSmallIntegerField(help_text='The amount of whiteboards available in this room.')),

                ('category', models.CharField(choices=[('LABORATORY', 'Laboratory'), ('CLASS_ROOM', 'Class room'), ('AUDITORIUM', 'Auditorium'), ('PC_ROOM', 'PC room'), ('PUBLIC_ROOM', 'Public room'), ('OFFICE', 'Office'), ('PRIVATE_ROOM', 'Private room'), ('WORKSHOP', 'Workshop'), ('OTHER', 'Other')], help_text='The category that best suits the character of this room.', max_length=16)),

                ('reservable', models.BooleanField(default=True, help_text='Indicates if this room can be reserved for something.')),

                ('note', models.TextField(blank=True, help_text="If some additional info is required for this room, like a characteristic property (e.g. 'Usually occupied by 2BACH informatics'), state it here.")),

            ],

        ),

        migrations.CreateModel(

            name='RoomReservation',

            fields=[

                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),

                ('timestamp', models.DateTimeField(auto_now_add=True)),

                ('start_time', models.DateTimeField(help_text='The time that this reservation starts.')),

                ('end_time', models.DateTimeField(help_text='The time that this reservation ends.')),

                ('seats', models.PositiveSmallIntegerField(help_text='Indicates how many seats are required. If this is left null, it is assumed the entire room has to be reserved.', null=True)),

                ('reason', models.CharField(blank=True, help_text='The reason for this reservation, if useful.', max_length=64)),

                ('note', models.TextField(blank=True, help_text='If some additional info is required for this reservation, state it here.')),

                ('reservator', models.ForeignKey(editable=False, help_text='The person that made the reservation (and thus responsible).', on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),

                ('room', models.ForeignKey(editable=False, help_text='The room that is being reserved at this point.', limit_choices_to={'reservable': True}, on_delete=django.db.models.deletion.CASCADE, to='administration.Room')),

            ],

        ),

    ]