# Generated by Django 5.2.17 on 2026-09-26 16:44

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


class Migration(migrations.Migration):

    initial = True

    dependencies = [
        ('catalog', '0002_deviceidentificationpolicy'),
    ]

    operations = [
        migrations.CreateModel(
            name='Device',
            fields=[
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
                ('is_active', models.BooleanField(default=True)),
                ('product_model', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='devices', to='catalog.productmodel')),
                ('product_variant', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, related_name='devices', to='catalog.productvariant')),
            ],
            options={
                'ordering': ['created_at', 'id'],
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='DeviceIdentifier',
            fields=[
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
                ('is_active', models.BooleanField(default=True)),
                ('identifier_type', models.CharField(choices=[('IMEI1', 'IMEI 1'), ('IMEI2', 'IMEI 2'), ('SERIAL', 'Serial')], max_length=6)),
                ('value', models.CharField(max_length=128)),
                ('normalized_value', models.CharField(editable=False, max_length=128)),
                ('identity_key', models.CharField(editable=False, max_length=128)),
                ('device', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='identifiers', to='devices.device')),
            ],
            options={
                'ordering': ['created_at', 'id'],
                'abstract': False,
                'constraints': [models.CheckConstraint(condition=models.Q(('identifier_type__in', ['IMEI1', 'IMEI2', 'SERIAL'])), name='devices_identifier_type_valid'), models.CheckConstraint(condition=models.Q(models.Q(('value', ''), _negated=True), models.Q(('normalized_value', ''), _negated=True), models.Q(('identity_key', ''), _negated=True)), name='devices_identifier_nonblank'), models.CheckConstraint(condition=models.Q(('identifier_type', 'SERIAL'), models.Q(('normalized_value__regex', '^[0-9]{15}$'), ('identity_key', models.F('normalized_value'))), _connector='OR'), name='devices_imei_canonical'), models.UniqueConstraint(condition=models.Q(('is_active', True)), fields=('device', 'identifier_type'), name='devices_active_slot_uniq'), models.UniqueConstraint(condition=models.Q(('identifier_type__in', ['IMEI1', 'IMEI2'])), fields=('normalized_value',), name='devices_imei_reserved_uniq'), models.UniqueConstraint(condition=models.Q(('identifier_type', 'SERIAL')), fields=('normalized_value',), name='devices_serial_reserved_uniq'), models.UniqueConstraint(fields=('identity_key',), name='devices_identity_key_reserved_uniq')],
            },
        ),
    ]