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.
operations =
[<CreateModel name='DepartmentCosts', fields=[('id', <django.db.models.fields.BigAutoField>), ('equivalents_per_hour', <django.db.models.fields.DecimalField>)], options={'verbose_name': 'department costs', 'verbose_name_plural': 'department costs', 'default_permissions': ()}>, <CreateModel name='DepartmentDate', fields=[('id', <django.db.models.fields.BigAutoField>), ('date', <django.db.models.fields.DateField>)], options={'verbose_name': 'department interval', 'verbose_name_plural': 'department intervals', 'default_permissions': ()}>, <CreateModel name='GeneralCosts', fields=[('id', <django.db.models.fields.BigAutoField>), ('start', <django.db.models.fields.DateField>), ('costs', <django.db.models.fields.DecimalField>)], options={'verbose_name': 'general costs', 'verbose_name_plural': 'general costs', 'default_permissions': ()}>, <CreateModel name='ProjectFundedStaff', fields=[('id', <django.db.models.fields.BigAutoField>), ('hours', <django.db.models.fields.DecimalField>)], options={'verbose_name': 'project funded staff', 'verbose_name_plural': 'project funded staff', 'default_permissions': ()}>, <CreateModel name='ProjectFundedStaffDate', fields=[('id', <django.db.models.fields.BigAutoField>), ('date', <django.db.models.fields.DateField>)], options={'verbose_name': 'project funded staff interval', 'verbose_name_plural': 'project funded staff intervals', 'default_permissions': ()}>, <CreateModel name='Receipt', fields=[('id', <django.db.models.fields.BigAutoField>), ('start', <django.db.models.fields.DateField>), ('end', <django.db.models.fields.DateField>), ('create_time', <django.db.models.fields.DateTimeField>), ('data', <django.db.models.fields.json.JSONField>)], options={'verbose_name': 'receipt', 'verbose_name_plural': 'receipts', 'default_permissions': ()}>, <CreateModel name='ReceiptTemplate', fields=[('id', <django.db.models.fields.BigAutoField>), ('start', <django.db.models.fields.DateField>), ('data', <django.db.models.fields.json.JSONField>)], options={'verbose_name': 'receipt template', 'verbose_name_plural': 'receipt templates', 'default_permissions': ()}>, <CreateModel name='SalaryLevelCosts', fields=[('id', <django.db.models.fields.BigAutoField>), ('brutto_per_hour', <django.db.models.fields.DecimalField>)], options={'verbose_name': 'salary level costs', 'verbose_name_plural': 'salary level costs', 'default_permissions': ()}>, <CreateModel name='SalaryLevelDate', fields=[('id', <django.db.models.fields.BigAutoField>), ('date', <django.db.models.fields.DateField>)], options={'verbose_name': 'salary interval', 'verbose_name_plural': 'salary intervals', 'default_permissions': ()}>, <AlterField model_name='project', name='department', field=<django.db.models.fields.related.ForeignKey>>, <AddConstraint model_name='salaryleveldate', constraint=<UniqueConstraint: fields=('date',) name='unique_constraint_salary_level_date'>>, <AddField model_name='salarylevelcosts', name='salary_level', field=<django.db.models.fields.related.ForeignKey>>, <AddField model_name='salarylevelcosts', name='start', field=<django.db.models.fields.related.ForeignKey>>, <AddConstraint model_name='receipttemplate', constraint=<UniqueConstraint: fields=('start',) name='unique_constraint_receipt_template_start'>>, <AddField model_name='receipt', name='project', field=<django.db.models.fields.related.ForeignKey>>, <AddField model_name='projectfundedstaffdate', name='project', field=<django.db.models.fields.related.ForeignKey>>, <AddField model_name='projectfundedstaff', name='salary_level', field=<django.db.models.fields.related.ForeignKey>>, <AddField model_name='projectfundedstaff', name='start', field=<django.db.models.fields.related.ForeignKey>>, <AddConstraint model_name='generalcosts', constraint=<UniqueConstraint: fields=('start',) name='unique_constraint_general_costs'>>, <AddConstraint model_name='departmentdate', constraint=<UniqueConstraint: fields=('date',) name='unique_constraint_department_date'>>, <AddField model_name='departmentcosts', name='department', field=<django.db.models.fields.related.ForeignKey>>, <AddField model_name='departmentcosts', name='start', field=<django.db.models.fields.related.ForeignKey>>, <AddConstraint model_name='salarylevelcosts', constraint=<UniqueConstraint: fields=('salary_level', 'start') name='unique_constraint_salary_level_costs'>>, <AddConstraint model_name='receipt', constraint=<CheckConstraint: check=(AND: ('start__lte', F(end))) name='interval_check_receipt'>>, <AddConstraint model_name='projectfundedstaffdate', constraint=<UniqueConstraint: fields=('date', 'project') name='unique_constraint_project_funded_staff_date'>>, <AddConstraint model_name='projectfundedstaff', constraint=<UniqueConstraint: fields=('salary_level', 'start') name='unique_constraint_project_funded_staff'>>, <AddConstraint model_name='departmentcosts', constraint=<UniqueConstraint: fields=('department', 'start') name='unique_constraint_department_costs'>>]
Inherited Members
- django.db.migrations.migration.Migration
- Migration
- run_before
- replaces
- initial
- atomic
- name
- app_label
- mutate_state
- apply
- unapply
- suggest_name