using FluentMigrator;

namespace InventoryContact.Db.Migrations;

[Migration(202504240143, "Init direct contact plugin")]
public class DirectContact_Init : Migration
{
    public override void Up()
    {
        Create.Table("DcContactMeta")
            .WithColumn("Id").AsInt32().PrimaryKey().Identity()
            .WithColumn("Slug").AsString(32).Indexed("IX_DcContactMeta_Slug").Unique()
            .WithColumn("SourceLocation").AsString()
            .WithColumn("MessageItemName").AsString()
            .WithColumn("CreatedAt").AsDateTime().WithDefault(SystemMethods.CurrentUTCDateTime);

        Create.Table("DcMessageLogs")
            .WithColumn("Id").AsInt32().PrimaryKey().Identity()
            .WithColumn("ContactMetaId").AsInt32().ForeignKey("DcContactMeta", "Id")
            .WithColumn("DisplayName").AsString(32).Nullable()
            .WithColumn("Text").AsString(512)
            .WithColumn("ContactInformation").AsString(64).Nullable()
            .WithColumn("CreatedAt").AsDateTime().WithDefault(SystemMethods.CurrentUTCDateTime);
    }

    public override void Down()
    {
    }
}