# Generated by Django 6.1 on 2026-08-18 06:14

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


class Migration(migrations.Migration):

    initial = True

    dependencies = [
        ('domains', '0001_initial'),
    ]

    operations = [
        migrations.CreateModel(
            name='Sitemap',
            fields=[
                ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('location', models.URLField(max_length=2000)),
                ('kind', models.CharField(choices=[('INDEX', 'Índice de sitemaps'), ('URLSET', 'Lista de URLs')], default='URLSET', max_length=10)),
                ('source', models.CharField(choices=[('DECLARED', 'Registrado a mano'), ('DISCOVERED', 'Hallado en un índice')], default='DECLARED', max_length=12)),
                ('url_count', models.PositiveIntegerField(default=0)),
                ('content_hash', models.CharField(blank=True, default='', max_length=64)),
                ('last_read_at', models.DateTimeField(blank=True, null=True)),
                ('last_submitted_at', models.DateTimeField(blank=True, null=True)),
                ('submitted_content_hash', models.CharField(blank=True, default='', max_length=64)),
                ('last_submit_result', models.CharField(blank=True, choices=[('OK', 'Enviado'), ('FAILED', 'Falló'), ('SKIPPED_UNCHANGED', 'Sin cambios, no se reenvió')], default='', max_length=20)),
                ('last_error', models.TextField(blank=True, default='')),
                ('domain', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='sitemaps', to='domains.domain')),
                ('parent', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='children', to='sitemaps.sitemap')),
            ],
            options={
                'ordering': ['location'],
            },
        ),
        migrations.CreateModel(
            name='Url',
            fields=[
                ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('loc', models.URLField(max_length=2000)),
                ('in_sitemap', models.BooleanField(default=True)),
                ('first_seen_at', models.DateTimeField(auto_now_add=True)),
                ('last_seen_in_sitemap_at', models.DateTimeField(blank=True, null=True)),
                ('coverage_state', models.CharField(choices=[('UNKNOWN', 'Sin consultar todavía'), ('INDEXED', 'Indexada'), ('CRAWLED_NOT_INDEXED', 'Rastreada, sin indexar'), ('DISCOVERED_NOT_INDEXED', 'Descubierta, sin rastrear'), ('DUPLICATE_CANONICAL', 'Duplicada con otra canónica'), ('EXCLUDED_NOINDEX', 'Excluida por noindex'), ('BLOCKED_ROBOTS', 'Bloqueada por robots.txt'), ('FETCH_ERROR', 'Error al descargarla'), ('REDIRECT', 'Redirecciona a otra URL'), ('OTHER_NOT_INDEXED', 'Sin indexar, otro motivo')], default='UNKNOWN', max_length=25)),
                ('last_checked_at', models.DateTimeField(blank=True, null=True)),
                ('priority_score', models.IntegerField(default=0)),
                ('domain', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='urls', to='domains.domain')),
                ('sitemap', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='urls', to='sitemaps.sitemap')),
            ],
            options={
                'ordering': ['loc'],
            },
        ),
        migrations.AddConstraint(
            model_name='sitemap',
            constraint=models.UniqueConstraint(fields=('domain', 'location'), name='un_sitemap_por_ubicacion_y_dominio'),
        ),
        migrations.AddIndex(
            model_name='url',
            index=models.Index(fields=['domain', 'coverage_state'], name='sitemaps_ur_domain__663394_idx'),
        ),
        migrations.AddIndex(
            model_name='url',
            index=models.Index(fields=['domain', 'last_checked_at'], name='sitemaps_ur_domain__a574bd_idx'),
        ),
        migrations.AddIndex(
            model_name='url',
            index=models.Index(fields=['domain', 'in_sitemap', 'priority_score'], name='sitemaps_ur_domain__8b7e0f_idx'),
        ),
        migrations.AddConstraint(
            model_name='url',
            constraint=models.UniqueConstraint(fields=('domain', 'loc'), name='una_url_por_dominio'),
        ),
    ]