vkk.migrations.0002_departmentcosts_departmentdate_generalcosts_and_more

  1# Generated by Django 4.1.3 on 2022-12-01 19:38
  2
  3from django.db import migrations, models
  4import django.db.models.deletion
  5
  6
  7class Migration(migrations.Migration):
  8
  9    dependencies = [
 10        ('vkk', '0001_initial'),
 11    ]
 12
 13    operations = [
 14        migrations.CreateModel(
 15            name='DepartmentCosts',
 16            fields=[
 17                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
 18                ('equivalents_per_hour', models.DecimalField(decimal_places=2, max_digits=8, verbose_name='full time equivalents per hour')),
 19            ],
 20            options={
 21                'verbose_name': 'department costs',
 22                'verbose_name_plural': 'department costs',
 23                'default_permissions': (),
 24            },
 25        ),
 26        migrations.CreateModel(
 27            name='DepartmentDate',
 28            fields=[
 29                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
 30                ('date', models.DateField(verbose_name='start date')),
 31            ],
 32            options={
 33                'verbose_name': 'department interval',
 34                'verbose_name_plural': 'department intervals',
 35                'default_permissions': (),
 36            },
 37        ),
 38        migrations.CreateModel(
 39            name='GeneralCosts',
 40            fields=[
 41                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
 42                ('start', models.DateField(verbose_name='start date')),
 43                ('costs', models.DecimalField(decimal_places=2, max_digits=8, verbose_name='general costs')),
 44            ],
 45            options={
 46                'verbose_name': 'general costs',
 47                'verbose_name_plural': 'general costs',
 48                'default_permissions': (),
 49            },
 50        ),
 51        migrations.CreateModel(
 52            name='ProjectFundedStaff',
 53            fields=[
 54                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
 55                ('hours', models.DecimalField(decimal_places=2, max_digits=8)),
 56            ],
 57            options={
 58                'verbose_name': 'project funded staff',
 59                'verbose_name_plural': 'project funded staff',
 60                'default_permissions': (),
 61            },
 62        ),
 63        migrations.CreateModel(
 64            name='ProjectFundedStaffDate',
 65            fields=[
 66                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
 67                ('date', models.DateField(verbose_name='start date')),
 68            ],
 69            options={
 70                'verbose_name': 'project funded staff interval',
 71                'verbose_name_plural': 'project funded staff intervals',
 72                'default_permissions': (),
 73            },
 74        ),
 75        migrations.CreateModel(
 76            name='Receipt',
 77            fields=[
 78                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
 79                ('start', models.DateField(verbose_name='start date')),
 80                ('end', models.DateField(verbose_name='end date')),
 81                ('create_time', models.DateTimeField(auto_now_add=True, verbose_name='time booked')),
 82                ('data', models.JSONField()),
 83            ],
 84            options={
 85                'verbose_name': 'receipt',
 86                'verbose_name_plural': 'receipts',
 87                'default_permissions': (),
 88            },
 89        ),
 90        migrations.CreateModel(
 91            name='ReceiptTemplate',
 92            fields=[
 93                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
 94                ('start', models.DateField(verbose_name='start date')),
 95                ('data', models.JSONField()),
 96            ],
 97            options={
 98                'verbose_name': 'receipt template',
 99                'verbose_name_plural': 'receipt templates',
100                'default_permissions': (),
101            },
102        ),
103        migrations.CreateModel(
104            name='SalaryLevelCosts',
105            fields=[
106                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
107                ('brutto_per_hour', models.DecimalField(decimal_places=2, max_digits=8, verbose_name='brutto staff costs per hour')),
108            ],
109            options={
110                'verbose_name': 'salary level costs',
111                'verbose_name_plural': 'salary level costs',
112                'default_permissions': (),
113            },
114        ),
115        migrations.CreateModel(
116            name='SalaryLevelDate',
117            fields=[
118                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
119                ('date', models.DateField(verbose_name='start date')),
120            ],
121            options={
122                'verbose_name': 'salary interval',
123                'verbose_name_plural': 'salary intervals',
124                'default_permissions': (),
125            },
126        ),
127        migrations.AlterField(
128            model_name='project',
129            name='department',
130            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to='vkk.department', verbose_name='department'),
131        ),
132        migrations.AddConstraint(
133            model_name='salaryleveldate',
134            constraint=models.UniqueConstraint(fields=('date',), name='unique_constraint_salary_level_date'),
135        ),
136        migrations.AddField(
137            model_name='salarylevelcosts',
138            name='salary_level',
139            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='vkk.salarylevel', verbose_name='salary level'),
140        ),
141        migrations.AddField(
142            model_name='salarylevelcosts',
143            name='start',
144            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='vkk.salaryleveldate', verbose_name='start date'),
145        ),
146        migrations.AddConstraint(
147            model_name='receipttemplate',
148            constraint=models.UniqueConstraint(fields=('start',), name='unique_constraint_receipt_template_start'),
149        ),
150        migrations.AddField(
151            model_name='receipt',
152            name='project',
153            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='vkk.project', verbose_name='project'),
154        ),
155        migrations.AddField(
156            model_name='projectfundedstaffdate',
157            name='project',
158            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='vkk.project', verbose_name='project'),
159        ),
160        migrations.AddField(
161            model_name='projectfundedstaff',
162            name='salary_level',
163            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='vkk.salarylevel', verbose_name='salary level'),
164        ),
165        migrations.AddField(
166            model_name='projectfundedstaff',
167            name='start',
168            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='vkk.projectfundedstaffdate', verbose_name='start date'),
169        ),
170        migrations.AddConstraint(
171            model_name='generalcosts',
172            constraint=models.UniqueConstraint(fields=('start',), name='unique_constraint_general_costs'),
173        ),
174        migrations.AddConstraint(
175            model_name='departmentdate',
176            constraint=models.UniqueConstraint(fields=('date',), name='unique_constraint_department_date'),
177        ),
178        migrations.AddField(
179            model_name='departmentcosts',
180            name='department',
181            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='vkk.department', verbose_name='department'),
182        ),
183        migrations.AddField(
184            model_name='departmentcosts',
185            name='start',
186            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='vkk.departmentdate', verbose_name='start date'),
187        ),
188        migrations.AddConstraint(
189            model_name='salarylevelcosts',
190            constraint=models.UniqueConstraint(fields=('salary_level', 'start'), name='unique_constraint_salary_level_costs'),
191        ),
192        migrations.AddConstraint(
193            model_name='receipt',
194            constraint=models.CheckConstraint(check=models.Q(('start__lte', models.F('end'))), name='interval_check_receipt'),
195        ),
196        migrations.AddConstraint(
197            model_name='projectfundedstaffdate',
198            constraint=models.UniqueConstraint(fields=('date', 'project'), name='unique_constraint_project_funded_staff_date'),
199        ),
200        migrations.AddConstraint(
201            model_name='projectfundedstaff',
202            constraint=models.UniqueConstraint(fields=('salary_level', 'start'), name='unique_constraint_project_funded_staff'),
203        ),
204        migrations.AddConstraint(
205            model_name='departmentcosts',
206            constraint=models.UniqueConstraint(fields=('department', 'start'), name='unique_constraint_department_costs'),
207        ),
208    ]
class Migration(django.db.migrations.migration.Migration):
  8class Migration(migrations.Migration):
  9
 10    dependencies = [
 11        ('vkk', '0001_initial'),
 12    ]
 13
 14    operations = [
 15        migrations.CreateModel(
 16            name='DepartmentCosts',
 17            fields=[
 18                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
 19                ('equivalents_per_hour', models.DecimalField(decimal_places=2, max_digits=8, verbose_name='full time equivalents per hour')),
 20            ],
 21            options={
 22                'verbose_name': 'department costs',
 23                'verbose_name_plural': 'department costs',
 24                'default_permissions': (),
 25            },
 26        ),
 27        migrations.CreateModel(
 28            name='DepartmentDate',
 29            fields=[
 30                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
 31                ('date', models.DateField(verbose_name='start date')),
 32            ],
 33            options={
 34                'verbose_name': 'department interval',
 35                'verbose_name_plural': 'department intervals',
 36                'default_permissions': (),
 37            },
 38        ),
 39        migrations.CreateModel(
 40            name='GeneralCosts',
 41            fields=[
 42                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
 43                ('start', models.DateField(verbose_name='start date')),
 44                ('costs', models.DecimalField(decimal_places=2, max_digits=8, verbose_name='general costs')),
 45            ],
 46            options={
 47                'verbose_name': 'general costs',
 48                'verbose_name_plural': 'general costs',
 49                'default_permissions': (),
 50            },
 51        ),
 52        migrations.CreateModel(
 53            name='ProjectFundedStaff',
 54            fields=[
 55                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
 56                ('hours', models.DecimalField(decimal_places=2, max_digits=8)),
 57            ],
 58            options={
 59                'verbose_name': 'project funded staff',
 60                'verbose_name_plural': 'project funded staff',
 61                'default_permissions': (),
 62            },
 63        ),
 64        migrations.CreateModel(
 65            name='ProjectFundedStaffDate',
 66            fields=[
 67                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
 68                ('date', models.DateField(verbose_name='start date')),
 69            ],
 70            options={
 71                'verbose_name': 'project funded staff interval',
 72                'verbose_name_plural': 'project funded staff intervals',
 73                'default_permissions': (),
 74            },
 75        ),
 76        migrations.CreateModel(
 77            name='Receipt',
 78            fields=[
 79                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
 80                ('start', models.DateField(verbose_name='start date')),
 81                ('end', models.DateField(verbose_name='end date')),
 82                ('create_time', models.DateTimeField(auto_now_add=True, verbose_name='time booked')),
 83                ('data', models.JSONField()),
 84            ],
 85            options={
 86                'verbose_name': 'receipt',
 87                'verbose_name_plural': 'receipts',
 88                'default_permissions': (),
 89            },
 90        ),
 91        migrations.CreateModel(
 92            name='ReceiptTemplate',
 93            fields=[
 94                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
 95                ('start', models.DateField(verbose_name='start date')),
 96                ('data', models.JSONField()),
 97            ],
 98            options={
 99                'verbose_name': 'receipt template',
100                'verbose_name_plural': 'receipt templates',
101                'default_permissions': (),
102            },
103        ),
104        migrations.CreateModel(
105            name='SalaryLevelCosts',
106            fields=[
107                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
108                ('brutto_per_hour', models.DecimalField(decimal_places=2, max_digits=8, verbose_name='brutto staff costs per hour')),
109            ],
110            options={
111                'verbose_name': 'salary level costs',
112                'verbose_name_plural': 'salary level costs',
113                'default_permissions': (),
114            },
115        ),
116        migrations.CreateModel(
117            name='SalaryLevelDate',
118            fields=[
119                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
120                ('date', models.DateField(verbose_name='start date')),
121            ],
122            options={
123                'verbose_name': 'salary interval',
124                'verbose_name_plural': 'salary intervals',
125                'default_permissions': (),
126            },
127        ),
128        migrations.AlterField(
129            model_name='project',
130            name='department',
131            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to='vkk.department', verbose_name='department'),
132        ),
133        migrations.AddConstraint(
134            model_name='salaryleveldate',
135            constraint=models.UniqueConstraint(fields=('date',), name='unique_constraint_salary_level_date'),
136        ),
137        migrations.AddField(
138            model_name='salarylevelcosts',
139            name='salary_level',
140            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='vkk.salarylevel', verbose_name='salary level'),
141        ),
142        migrations.AddField(
143            model_name='salarylevelcosts',
144            name='start',
145            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='vkk.salaryleveldate', verbose_name='start date'),
146        ),
147        migrations.AddConstraint(
148            model_name='receipttemplate',
149            constraint=models.UniqueConstraint(fields=('start',), name='unique_constraint_receipt_template_start'),
150        ),
151        migrations.AddField(
152            model_name='receipt',
153            name='project',
154            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='vkk.project', verbose_name='project'),
155        ),
156        migrations.AddField(
157            model_name='projectfundedstaffdate',
158            name='project',
159            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='vkk.project', verbose_name='project'),
160        ),
161        migrations.AddField(
162            model_name='projectfundedstaff',
163            name='salary_level',
164            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='vkk.salarylevel', verbose_name='salary level'),
165        ),
166        migrations.AddField(
167            model_name='projectfundedstaff',
168            name='start',
169            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='vkk.projectfundedstaffdate', verbose_name='start date'),
170        ),
171        migrations.AddConstraint(
172            model_name='generalcosts',
173            constraint=models.UniqueConstraint(fields=('start',), name='unique_constraint_general_costs'),
174        ),
175        migrations.AddConstraint(
176            model_name='departmentdate',
177            constraint=models.UniqueConstraint(fields=('date',), name='unique_constraint_department_date'),
178        ),
179        migrations.AddField(
180            model_name='departmentcosts',
181            name='department',
182            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='vkk.department', verbose_name='department'),
183        ),
184        migrations.AddField(
185            model_name='departmentcosts',
186            name='start',
187            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='vkk.departmentdate', verbose_name='start date'),
188        ),
189        migrations.AddConstraint(
190            model_name='salarylevelcosts',
191            constraint=models.UniqueConstraint(fields=('salary_level', 'start'), name='unique_constraint_salary_level_costs'),
192        ),
193        migrations.AddConstraint(
194            model_name='receipt',
195            constraint=models.CheckConstraint(check=models.Q(('start__lte', models.F('end'))), name='interval_check_receipt'),
196        ),
197        migrations.AddConstraint(
198            model_name='projectfundedstaffdate',
199            constraint=models.UniqueConstraint(fields=('date', 'project'), name='unique_constraint_project_funded_staff_date'),
200        ),
201        migrations.AddConstraint(
202            model_name='projectfundedstaff',
203            constraint=models.UniqueConstraint(fields=('salary_level', 'start'), name='unique_constraint_project_funded_staff'),
204        ),
205        migrations.AddConstraint(
206            model_name='departmentcosts',
207            constraint=models.UniqueConstraint(fields=('department', 'start'), name='unique_constraint_department_costs'),
208        ),
209    ]

The base class for all migrations.

Migration files will import this from django.db.migrations.Migration and subclass it as a class called Migration. It will have one or more of the following attributes:

  • operations: A list of Operation instances, probably from django.db.migrations.operations
  • dependencies: A list of tuples of (app_path, migration_name)
  • run_before: A list of tuples of (app_path, migration_name)
  • replaces: A list of migration_names

Note that all migrations come out of migrations and into the Loader or Graph as instances, having been initialized with their app label and name.

Inherited Members
django.db.migrations.migration.Migration
Migration
mutate_state
apply
unapply
suggest_name