AutoBet/AutoBet.Db/Migrations/20200227201354_RaceRunnerDetails.cs

using System;
using Microsoft.EntityFrameworkCore.Migrations;

namespace AutoBet.Db.Migrations
{
    public partial class RaceRunnerDetails : Migration
    {
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.AddColumn<int>(
                name: "AgeYear",
                table: "RunnerResults",
                nullable: false,
                defaultValue: 0);

            migrationBuilder.AddColumn<int>(
                name: "AnimalId",
                table: "RunnerResults",
                nullable: false,
                defaultValue: 0);

            migrationBuilder.AddColumn<string>(
                name: "BettingRatio",
                table: "RunnerResults",
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "Bred",
                table: "RunnerResults",
                nullable: true);

            migrationBuilder.AddColumn<int>(
                name: "ClothNumber",
                table: "RunnerResults",
                nullable: true);

            migrationBuilder.AddColumn<int>(
                name: "DivisionSequence",
                table: "RunnerResults",
                nullable: false,
                defaultValue: 0);

            migrationBuilder.AddColumn<int>(
                name: "DrawnStall",
                table: "RunnerResults",
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "FinishTime",
                table: "RunnerResults",
                nullable: true);

            migrationBuilder.AddColumn<int>(
                name: "FinishTimeInMilliseconds",
                table: "RunnerResults",
                nullable: true);

            migrationBuilder.AddColumn<int>(
                name: "HorseId",
                table: "RunnerResults",
                nullable: false,
                defaultValue: 0);

            migrationBuilder.AddColumn<int>(
                name: "Hro",
                table: "RunnerResults",
                nullable: false,
                defaultValue: 0);

            migrationBuilder.AddColumn<int>(
                name: "JockeyId",
                table: "RunnerResults",
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "JockeyName",
                table: "RunnerResults",
                nullable: true);

            migrationBuilder.AddColumn<int>(
                name: "JockeyProfile",
                table: "RunnerResults",
                nullable: false,
                defaultValue: 0);

            migrationBuilder.AddColumn<int>(
                name: "LossMilliseconds",
                table: "RunnerResults",
                nullable: false,
                defaultValue: 0);

            migrationBuilder.AddColumn<DateTime>(
                name: "NonRunnerDeclaredDate",
                table: "RunnerResults",
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "NonRunnerDeclaredReason",
                table: "RunnerResults",
                nullable: true);

            migrationBuilder.AddColumn<TimeSpan>(
                name: "NonRunnerDeclaredTime",
                table: "RunnerResults",
                nullable: true);

            migrationBuilder.AddColumn<int>(
                name: "OwnerId",
                table: "RunnerResults",
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "OwnerName",
                table: "RunnerResults",
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "PerformanceFigure",
                table: "RunnerResults",
                nullable: true);

            migrationBuilder.AddColumn<int>(
                name: "Plus10",
                table: "RunnerResults",
                nullable: false,
                defaultValue: 0);

            migrationBuilder.AddColumn<string>(
                name: "PositionFinishTime",
                table: "RunnerResults",
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "RaceCriteriaRaceType",
                table: "RunnerResults",
                nullable: true);

            migrationBuilder.AddColumn<int>(
                name: "RaceId",
                table: "RunnerResults",
                nullable: false,
                defaultValue: 0);

            migrationBuilder.AddColumn<string>(
                name: "RacehorseName",
                table: "RunnerResults",
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "RacehorseNameWithoutConuntry",
                table: "RunnerResults",
                nullable: true);

            migrationBuilder.AddColumn<int>(
                name: "Ran",
                table: "RunnerResults",
                nullable: false,
                defaultValue: 0);

            migrationBuilder.AddColumn<string>(
                name: "RatingAwt",
                table: "RunnerResults",
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "RatingChase",
                table: "RunnerResults",
                nullable: true);

            migrationBuilder.AddColumn<int>(
                name: "RatingFlat",
                table: "RunnerResults",
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "RatingHurdle",
                table: "RunnerResults",
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "ResultBtnDistance",
                table: "RunnerResults",
                nullable: true);

            migrationBuilder.AddColumn<int>(
                name: "ResultFinishPos",
                table: "RunnerResults",
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "SexType",
                table: "RunnerResults",
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "SilkImage",
                table: "RunnerResults",
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "Status",
                table: "RunnerResults",
                nullable: true);

            migrationBuilder.AddColumn<int>(
                name: "TrainerId",
                table: "RunnerResults",
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "TrainerName",
                table: "RunnerResults",
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "WbSilkCode",
                table: "RunnerResults",
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "WbSilkDescription",
                table: "RunnerResults",
                nullable: true);

            migrationBuilder.AddColumn<int>(
                name: "WeightValue",
                table: "RunnerResults",
                nullable: true);

            migrationBuilder.AddColumn<int>(
                name: "YearOfRace",
                table: "RunnerResults",
                nullable: false,
                defaultValue: 0);
        }

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

            migrationBuilder.DropColumn(
                name: "AnimalId",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "BettingRatio",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "Bred",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "ClothNumber",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "DivisionSequence",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "DrawnStall",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "FinishTime",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "FinishTimeInMilliseconds",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "HorseId",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "Hro",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "JockeyId",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "JockeyName",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "JockeyProfile",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "LossMilliseconds",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "NonRunnerDeclaredDate",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "NonRunnerDeclaredReason",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "NonRunnerDeclaredTime",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "OwnerId",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "OwnerName",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "PerformanceFigure",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "Plus10",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "PositionFinishTime",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "RaceCriteriaRaceType",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "RaceId",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "RacehorseName",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "RacehorseNameWithoutConuntry",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "Ran",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "RatingAwt",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "RatingChase",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "RatingFlat",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "RatingHurdle",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "ResultBtnDistance",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "ResultFinishPos",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "SexType",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "SilkImage",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "Status",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "TrainerId",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "TrainerName",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "WbSilkCode",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "WbSilkDescription",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "WeightValue",
                table: "RunnerResults");

            migrationBuilder.DropColumn(
                name: "YearOfRace",
                table: "RunnerResults");
        }
    }
}