# Generated by Django 4.2.2 on 2025-11-04 12:14

from django.db import migrations, models
import django.db.models.functions.text


class Migration(migrations.Migration):

    dependencies = [
        ('mydevicemanagement', '0008_alter_customerdevice_density_unit_and_more'),
    ]

    operations = [
        migrations.AlterField(
            model_name='customerdevice',
            name='serial_number',
            field=models.CharField(db_index=True, help_text='Physical device serial; must be globally unique.', max_length=100),
        ),
        migrations.AddIndex(
            model_name='customerdevice',
            index=models.Index(django.db.models.functions.text.Lower('serial_number'), name='idx_serial_number_lower'),
        ),
        migrations.AddConstraint(
            model_name='customerdevice',
            constraint=models.UniqueConstraint(django.db.models.functions.text.Lower('device_label'), models.F('customer'), name='uniq_device_label_per_customer_ci'),
        ),
        migrations.AddConstraint(
            model_name='customerdevice',
            constraint=models.UniqueConstraint(django.db.models.functions.text.Lower('serial_number'), models.F('customer'), name='uniq_serial_per_customer_ci'),
        ),
    ]