Untitled

 avatar
unknown
plain_text
a year ago
6.7 kB
3
Indexable
using Microsoft.EntityFrameworkCore.Migrations;

#nullable disable

namespace EduPortal.Persistence.Migrations
{
    /// <inheritdoc />
    public partial class addAddressData : Migration
    {
        /// <inheritdoc />
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropForeignKey(
                name: "FK_Invoices_Subscribers_SubscriberId",
                table: "Invoices");

            migrationBuilder.AlterColumn<int>(
                name: "SubscriberId",
                table: "Invoices",
                type: "int",
                nullable: false,
                defaultValue: 0,
                oldClrType: typeof(int),
                oldType: "int",
                oldNullable: true);

            migrationBuilder.CreateTable(
                name: "Ad_Diskapi",
                columns: table => new
                {
                    disKapiKimlikNo = table.Column<long>(type: "bigint", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    adi = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    sokakKimlikNo = table.Column<long>(type: "bigint", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Ad_Diskapi", x => x.disKapiKimlikNo);
                });

            migrationBuilder.CreateTable(
                name: "Ad_IcKapi",
                columns: table => new
                {
                    icKapiKimlikNo = table.Column<long>(type: "bigint", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    adresNo = table.Column<string>(type: "nvarchar(max)", nullable: false),
                    disKapiKimlikNo = table.Column<long>(type: "bigint", nullable: false),
                    sokakKimlikNo = table.Column<long>(type: "bigint", nullable: false),
                    mahalleKimlikNo = table.Column<int>(type: "int", nullable: false),
                    ilceKimlikNo = table.Column<int>(type: "int", nullable: false),
                    katNo = table.Column<int>(type: "int", nullable: false),
                    icKapiNo = table.Column<int>(type: "int", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Ad_IcKapi", x => x.icKapiKimlikNo);
                });

            migrationBuilder.CreateTable(
                name: "Ad_Ilceler",
                columns: table => new
                {
                    ilceKimlikNo = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    adi = table.Column<string>(type: "nvarchar(max)", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Ad_Ilceler", x => x.ilceKimlikNo);
                });

            migrationBuilder.CreateTable(
                name: "Ad_Mahalleler",
                columns: table => new
                {
                    mahalleKimlikNo = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    adi = table.Column<string>(type: "nvarchar(max)", nullable: false),
                    ilceKimlikNo = table.Column<int>(type: "int", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Ad_Mahalleler", x => x.mahalleKimlikNo);
                });

            migrationBuilder.CreateTable(
                name: "Ad_Sayac",
                columns: table => new
                {
                    counterNumber = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    icKapiKimlikNo = table.Column<long>(type: "bigint", nullable: false),
                    active = table.Column<bool>(type: "bit", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Ad_Sayac", x => x.counterNumber);
                });

            migrationBuilder.CreateTable(
                name: "Ad_Sokaklar",
                columns: table => new
                {
                    sokakKimlikNo = table.Column<long>(type: "bigint", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    adi = table.Column<string>(type: "nvarchar(max)", nullable: false),
                    mahalleKimlikNo = table.Column<int>(type: "int", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Ad_Sokaklar", x => x.sokakKimlikNo);
                });

            migrationBuilder.AddForeignKey(
                name: "FK_Invoices_Subscribers_SubscriberId",
                table: "Invoices",
                column: "SubscriberId",
                principalTable: "Subscribers",
                principalColumn: "Id",
                onDelete: ReferentialAction.Cascade);
        }

        /// <inheritdoc />
        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropForeignKey(
                name: "FK_Invoices_Subscribers_SubscriberId",
                table: "Invoices");

            migrationBuilder.DropTable(
                name: "Ad_Diskapi");

            migrationBuilder.DropTable(
                name: "Ad_IcKapi");

            migrationBuilder.DropTable(
                name: "Ad_Ilceler");

            migrationBuilder.DropTable(
                name: "Ad_Mahalleler");

            migrationBuilder.DropTable(
                name: "Ad_Sayac");

            migrationBuilder.DropTable(
                name: "Ad_Sokaklar");

            migrationBuilder.AlterColumn<int>(
                name: "SubscriberId",
                table: "Invoices",
                type: "int",
                nullable: true,
                oldClrType: typeof(int),
                oldType: "int");

            migrationBuilder.AddForeignKey(
                name: "FK_Invoices_Subscribers_SubscriberId",
                table: "Invoices",
                column: "SubscriberId",
                principalTable: "Subscribers",
                principalColumn: "Id");
        }
    }
}
Editor is loading...
Leave a Comment