Files

34 lines
1.1 KiB
C#

using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Metadata.Builders;
namespace DataServer.Data;
public sealed class Zone
{
public ulong Id { get; set; }
public string Name { get; set; } = "";
public double MinX { get; set; }
public double MinY { get; set; }
public double MinZ { get; set; }
public double MaxX { get; set; }
public double MaxY { get; set; }
public double MaxZ { get; set; }
public DateTime CreatedAt { get; set; }
public DateTime UpdatedAt { get; set; }
}
public sealed class ZoneConfig : IEntityTypeConfiguration<Zone>
{
public void Configure(EntityTypeBuilder<Zone> e)
{
e.ToTable("zones");
e.HasKey(x => x.Id);
e.Property(x => x.Id).ValueGeneratedOnAdd();
e.Property(x => x.Name).HasMaxLength(64).IsRequired();
e.HasIndex(x => x.Name).IsUnique();
e.Property(x => x.CreatedAt).HasDefaultValueSql("CURRENT_TIMESTAMP(6)");
e.Property(x => x.UpdatedAt).HasDefaultValueSql("CURRENT_TIMESTAMP(6)")
.ValueGeneratedOnAddOrUpdate();
}
}