using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Metadata.Builders;

namespace Nuuru.Server.Data.EntityConfigurations
{
    public class TagConfiguration : IEntityTypeConfiguration<Models.Booru.Tag>
    {
        public void Configure(EntityTypeBuilder<Models.Booru.Tag> builder)
        {
            // Unique constraint on Name + CategoryId (same name can exist with different categories)
            builder.HasIndex("Name", "CategoryId")
                .IsUnique();

            builder.HasIndex(t => t.PostCount);

            // Index for wildcard tag searches (StartsWith queries)
            builder.HasIndex(t => t.Name);
        }
    }
}