# Generated by Django 5.2.15 on 2026-07-07 13:27

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


class Migration(migrations.Migration):

    dependencies = [
        ("smehub_linkage", "0006_country_full_names"),
    ]

    operations = [
        migrations.CreateModel(
            name="AdvisorySlot",
            fields=[
                (
                    "id",
                    models.BigAutoField(
                        auto_created=True, primary_key=True, serialize=False, verbose_name="ID"
                    ),
                ),
                ("starts_at", models.DateTimeField()),
                ("duration_minutes", models.PositiveSmallIntegerField(default=60)),
                ("created_at", models.DateTimeField(auto_now_add=True)),
                (
                    "service_provider",
                    models.ForeignKey(
                        on_delete=django.db.models.deletion.CASCADE,
                        related_name="advisory_slots",
                        to="smehub_linkage.serviceproviderentry",
                    ),
                ),
                (
                    "session",
                    models.OneToOneField(
                        blank=True,
                        null=True,
                        on_delete=django.db.models.deletion.SET_NULL,
                        related_name="slot",
                        to="smehub_linkage.advisorysession",
                    ),
                ),
            ],
            options={
                "ordering": ["starts_at"],
                "indexes": [
                    models.Index(
                        fields=["service_provider", "starts_at"],
                        name="smehub_link_service_8a7ef6_idx",
                    )
                ],
                "constraints": [
                    models.UniqueConstraint(
                        fields=("service_provider", "starts_at"),
                        name="uniq_advisory_slot_per_provider_time",
                    )
                ],
            },
        ),
    ]