AD/main/migrations/0001_initial.py

# Generated by Django 5.0.2 on 2024-10-26 19:45

import django.db.models.deletion
from django.db import migrations, models


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='Employee',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=100)),
                ('daily_workhours', models.PositiveIntegerField()),
                ('info', models.TextField(blank=True, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='Helper',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('date', models.DateField()),
                ('ben', models.PositiveSmallIntegerField()),
                ('best', models.PositiveSmallIntegerField(blank=True, null=True)),
                ('info', models.TextField(blank=True, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='Location',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=100)),
            ],
        ),
        migrations.CreateModel(
            name='Reinigung',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('date', models.DateField()),
                ('auftrag', models.CharField(choices=[('Beauftragen', 'Beauftragen'), ('Bestellt', 'Bestellt')], default='', max_length=12, null=True)),
                ('info', models.TextField(blank=True, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='Event',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('date', models.DateField()),
                ('name', models.CharField(max_length=100)),
                ('event_type', models.CharField(choices=[('', 'None'), ('AU', 'Aufbau'), ('AB', 'Abbau'), ('UM', 'Umbau'), ('VA', 'VA-Tag'), ('ST', 'Spieltag'), ('TR', 'Training')], default='', max_length=2, null=True)),
                ('info', models.TextField(blank=True, null=True)),
                ('cvd', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='cvt', to='main.employee')),
                ('cvt', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='cvd', to='main.employee')),
                ('location', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='main.location')),
            ],
        ),
        migrations.CreateModel(
            name='Shift',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('date', models.DateField()),
                ('start', models.TimeField(blank=True, null=True)),
                ('end', models.TimeField(blank=True, null=True)),
                ('shifttype', models.CharField(choices=[('N', 'None'), ('U', 'Urlaub'), ('C', 'Catering'), ('K', 'Krank'), ('RB', 'Rufbereitschaft'), ('SO', 'Sonderdienst'), ('KKH', 'KKH'), ('ST', 'Stapler'), ('AH', 'Ausser Haus')], default='N', max_length=3, null=True)),
                ('employee', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='main.employee')),
            ],
        ),
    ]