GreenTree.Strohrmann.ERP/GreenTree.Strohrmann.ERP.Domain/Migrations/20200622114406_User_Mail.cs

using Microsoft.EntityFrameworkCore.Migrations;

namespace GreenTree.Strohrmann.ERP.Domain.Migrations
{
    public partial class User_Mail : Migration
    {
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.AddColumn<string>(
                name: "MailAddress",
                table: "Users",
                nullable: false);

            migrationBuilder.AddColumn<string>(
                name: "Password",
                table: "Users",
                nullable: false);

            // Set default password value for initialization
            migrationBuilder.Sql(
                "UPDATE Users " +
                "SET Password = 'a3b9c163f6c520407ff34cfdb83ca5c6' " +
                "WHERE Password IS NULL");
        }

        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropColumn(
                name: "MailAddress",
                table: "Users");

            migrationBuilder.DropColumn(
                name: "Password",
                table: "Users");
        }
    }
}