# Part 6 — course certificates + badge fields (NOT APPLIED YET)
# Review, then: python manage.py migrate courses 0010

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


class Migration(migrations.Migration):

    dependencies = [
        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
        ('courses', '0009_exam_engine'),
    ]

    operations = [
        migrations.AddField(
            model_name='course',
            name='certificate_code',
            field=models.CharField(blank=True, help_text='Short code in certificate numbers, e.g. SEO → TSN-SEO-2026-00001.', max_length=12),
        ),
        migrations.CreateModel(
            name='CourseCertificate',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('certificate_number', models.CharField(db_index=True, help_text='Public ID, e.g. TSN-SEO-2026-00001', max_length=64, unique=True)),
                ('issued_at', models.DateTimeField(auto_now_add=True)),
                ('score', models.DecimalField(decimal_places=2, max_digits=5)),
                ('score_band', models.CharField(choices=[('excellent', 'Passed — Excellent'), ('proficient', 'Passed — Proficient'), ('competent', 'Passed — Competent')], max_length=20)),
                ('status', models.CharField(choices=[('valid', 'Valid'), ('revoked', 'Revoked')], db_index=True, default='valid', max_length=20)),
                ('revoke_reason', models.TextField(blank=True)),
                ('revoked_at', models.DateTimeField(blank=True, null=True)),
                ('recipient_name', models.CharField(max_length=200)),
                ('privacy_initials_only', models.BooleanField(default=False, help_text='If True, public verify page shows initials instead of full name.')),
                ('course_title_snapshot', models.CharField(max_length=200)),
                ('pdf_file', models.FileField(blank=True, null=True, upload_to='course_certificates/pdf/')),
                ('badge_image', models.ImageField(blank=True, null=True, upload_to='course_certificates/badges/')),
                ('integrity_hash', models.CharField(blank=True, help_text='SHA-256 of certificate payload (digital integrity stamp).', max_length=64)),
                ('assets_ready', models.BooleanField(default=False, help_text='True once async PDF + badge generation has finished.')),
                ('attempt', models.OneToOneField(on_delete=django.db.models.deletion.PROTECT, related_name='certificate', to='courses.courseexamattempt')),
                ('course', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='certificates', to='courses.course')),
                ('revoked_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='revoked_course_certificates', to=settings.AUTH_USER_MODEL)),
                ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='course_certificates', to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'verbose_name': 'Course certificate',
                'verbose_name_plural': 'Course certificates',
                'ordering': ['-issued_at'],
            },
        ),
    ]