67 lines
3.0 KiB
Python
67 lines
3.0 KiB
Python
# Generated by Django 5.1.15 on 2026-05-02 15:24
|
|
|
|
import django.db.models.deletion
|
|
from django.conf import settings
|
|
from django.db import migrations, models
|
|
|
|
|
|
class Migration(migrations.Migration):
|
|
|
|
initial = True
|
|
|
|
dependencies = [
|
|
('courses', '0001_initial'),
|
|
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
|
|
]
|
|
|
|
operations = [
|
|
migrations.CreateModel(
|
|
name='Enrollment',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('enrolled_at', models.DateTimeField(auto_now_add=True, verbose_name='enrolled at')),
|
|
('completed_at', models.DateTimeField(blank=True, null=True, verbose_name='completed at')),
|
|
('course', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='enrollments', to='courses.course')),
|
|
('student', models.ForeignKey(limit_choices_to={'role': 'student'}, on_delete=django.db.models.deletion.CASCADE, related_name='enrollments', to=settings.AUTH_USER_MODEL)),
|
|
],
|
|
options={
|
|
'verbose_name': 'enrollment',
|
|
'verbose_name_plural': 'enrollments',
|
|
'ordering': ['-enrolled_at'],
|
|
},
|
|
),
|
|
migrations.CreateModel(
|
|
name='LessonProgress',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('completed_at', models.DateTimeField(blank=True, null=True, verbose_name='completed at')),
|
|
('enrollment', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='lesson_progress', to='enrollments.enrollment')),
|
|
('lesson', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='progress_records', to='courses.lesson')),
|
|
],
|
|
options={
|
|
'verbose_name': 'lesson progress',
|
|
'verbose_name_plural': 'lesson progress',
|
|
},
|
|
),
|
|
migrations.AddIndex(
|
|
model_name='enrollment',
|
|
index=models.Index(fields=['student', '-enrolled_at'], name='enrollments_student_dfac97_idx'),
|
|
),
|
|
migrations.AddIndex(
|
|
model_name='enrollment',
|
|
index=models.Index(fields=['course', '-enrolled_at'], name='enrollments_course__c1239d_idx'),
|
|
),
|
|
migrations.AddConstraint(
|
|
model_name='enrollment',
|
|
constraint=models.UniqueConstraint(fields=('student', 'course'), name='unique_enrollment_per_student_course'),
|
|
),
|
|
migrations.AddIndex(
|
|
model_name='lessonprogress',
|
|
index=models.Index(fields=['enrollment', 'lesson'], name='enrollments_enrollm_a65958_idx'),
|
|
),
|
|
migrations.AddConstraint(
|
|
model_name='lessonprogress',
|
|
constraint=models.UniqueConstraint(fields=('enrollment', 'lesson'), name='unique_progress_per_enrollment_lesson'),
|
|
),
|
|
]
|