FCC/Applications/Gateway/POS/PosApp/Migrations/20210526091426_addSourceTrxIdToRedeemAndRecharge.cs

using Microsoft.EntityFrameworkCore.Migrations;

namespace Gateway.POS.Migrations
{
    public partial class addSourceTrxIdToRedeemAndRecharge : Migration
    {
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropForeignKey(
                name: "FK_Transactions_MembershipProfitAccountRecharges_MembershipProfitAccountRechargeId",
                table: "Transactions");

            migrationBuilder.DropForeignKey(
                name: "FK_Transactions_MembershipProfitAccountRedeems_MembershipProfitAccountRedeemId",
                table: "Transactions");

            migrationBuilder.DropIndex(
                name: "IX_Transactions_MembershipProfitAccountRechargeId",
                table: "Transactions");

            migrationBuilder.DropIndex(
                name: "IX_Transactions_MembershipProfitAccountRedeemId",
                table: "Transactions");

            migrationBuilder.AddColumn<int>(
                name: "SourceTrxId",
                table: "MembershipProfitAccountRedeems",
                type: "INTEGER",
                nullable: true);

            migrationBuilder.AddColumn<int>(
                name: "SourceTrxId",
                table: "MembershipProfitAccountRecharges",
                type: "INTEGER",
                nullable: true);

            migrationBuilder.CreateIndex(
                name: "IX_MembershipProfitAccountRedeems_SourceTrxId",
                table: "MembershipProfitAccountRedeems",
                column: "SourceTrxId",
                unique: true);

            migrationBuilder.CreateIndex(
                name: "IX_MembershipProfitAccountRecharges_SourceTrxId",
                table: "MembershipProfitAccountRecharges",
                column: "SourceTrxId",
                unique: true);

            migrationBuilder.AddForeignKey(
                name: "FK_MembershipProfitAccountRecharges_Transactions_SourceTrxId",
                table: "MembershipProfitAccountRecharges",
                column: "SourceTrxId",
                principalTable: "Transactions",
                principalColumn: "Id",
                onDelete: ReferentialAction.Restrict);

            migrationBuilder.AddForeignKey(
                name: "FK_MembershipProfitAccountRedeems_Transactions_SourceTrxId",
                table: "MembershipProfitAccountRedeems",
                column: "SourceTrxId",
                principalTable: "Transactions",
                principalColumn: "Id",
                onDelete: ReferentialAction.Restrict);
        }

        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropForeignKey(
                name: "FK_MembershipProfitAccountRecharges_Transactions_SourceTrxId",
                table: "MembershipProfitAccountRecharges");

            migrationBuilder.DropForeignKey(
                name: "FK_MembershipProfitAccountRedeems_Transactions_SourceTrxId",
                table: "MembershipProfitAccountRedeems");

            migrationBuilder.DropIndex(
                name: "IX_MembershipProfitAccountRedeems_SourceTrxId",
                table: "MembershipProfitAccountRedeems");

            migrationBuilder.DropIndex(
                name: "IX_MembershipProfitAccountRecharges_SourceTrxId",
                table: "MembershipProfitAccountRecharges");

            migrationBuilder.DropColumn(
                name: "SourceTrxId",
                table: "MembershipProfitAccountRedeems");

            migrationBuilder.DropColumn(
                name: "SourceTrxId",
                table: "MembershipProfitAccountRecharges");

            migrationBuilder.CreateIndex(
                name: "IX_Transactions_MembershipProfitAccountRechargeId",
                table: "Transactions",
                column: "MembershipProfitAccountRechargeId");

            migrationBuilder.CreateIndex(
                name: "IX_Transactions_MembershipProfitAccountRedeemId",
                table: "Transactions",
                column: "MembershipProfitAccountRedeemId");

            migrationBuilder.AddForeignKey(
                name: "FK_Transactions_MembershipProfitAccountRecharges_MembershipProfitAccountRechargeId",
                table: "Transactions",
                column: "MembershipProfitAccountRechargeId",
                principalTable: "MembershipProfitAccountRecharges",
                principalColumn: "Id",
                onDelete: ReferentialAction.Restrict);

            migrationBuilder.AddForeignKey(
                name: "FK_Transactions_MembershipProfitAccountRedeems_MembershipProfitAccountRedeemId",
                table: "Transactions",
                column: "MembershipProfitAccountRedeemId",
                principalTable: "MembershipProfitAccountRedeems",
                principalColumn: "Id",
                onDelete: ReferentialAction.Restrict);
        }
    }
}