StaffPerformance/wispro.sp.api/Migrations/20210910105657_spDB0910.cs

using System;
using Microsoft.EntityFrameworkCore.Migrations;

namespace wispro.sp.api.Migrations
{
    public partial class spDB0910 : Migration
    {
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.CreateTable(
                name: "StaffGrade",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Grade = table.Column<string>(type: "nchar(5)", fixedLength: true, maxLength: 5, nullable: false),
                    Coefficient = table.Column<double>(type: "float", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_StaffGrade", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Staff",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false),
                    Account = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false),
                    Password = table.Column<string>(type: "nvarchar(max)", nullable: false),
                    Name = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: false),
                    Status = table.Column<string>(type: "nvarchar(25)", maxLength: 25, nullable: false),
                    isCalPerformsnce = table.Column<bool>(type: "bit", nullable: false),
                    StaffGradeId = table.Column<int>(type: "int", nullable: false),
                    Department = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    WorkPlace = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    EntyDate = table.Column<DateTime>(type: "date", nullable: true),
                    Memo = table.Column<string>(type: "nvarchar(max)", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Staff", x => x.Id);
                    table.ForeignKey(
                        name: "FK_Staff_StaffGrade",
                        column: x => x.StaffGradeId,
                        principalTable: "StaffGrade",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Restrict);
                });

            migrationBuilder.CreateTable(
                name: "VerifyCoefficient",
                columns: table => new
                {
                    CheckerId = table.Column<int>(type: "int", nullable: false),
                    DoPersonId = table.Column<int>(type: "int", nullable: false),
                    Coefficient = table.Column<double>(type: "float", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_VerifyCoefficient", x => new { x.CheckerId, x.DoPersonId });
                    table.ForeignKey(
                        name: "FK_VerifyCoefficient_StaffGrade",
                        column: x => x.CheckerId,
                        principalTable: "StaffGrade",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Restrict);
                    table.ForeignKey(
                        name: "FK_VerifyCoefficient_StaffGrade1",
                        column: x => x.DoPersonId,
                        principalTable: "StaffGrade",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Restrict);
                });

            migrationBuilder.CreateTable(
                name: "Customer",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false),
                    Name = table.Column<string>(type: "nvarchar(200)", maxLength: 200, nullable: false),
                    ContactMan = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    Address = table.Column<string>(type: "nvarchar(500)", maxLength: 500, nullable: true),
                    Phone = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    ResponseManId = table.Column<int>(type: "int", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Customer", x => x.Id);
                    table.ForeignKey(
                        name: "FK_Customer_Staff",
                        column: x => x.ResponseManId,
                        principalTable: "Staff",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Restrict);
                });

            migrationBuilder.CreateTable(
                name: "PerformanceItem",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Year = table.Column<int>(type: "int", nullable: false),
                    Month = table.Column<int>(type: "int", nullable: false),
                    CaseNo = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    ApplicationType = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    BusinessType = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    AgentFeedbackMemo = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    DoItem = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    CaseStage = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    CaseCoefficient = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true),
                    DoItemCoefficient = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    PreOAStaffId = table.Column<int>(type: "int", nullable: true),
                    ReviewerId = table.Column<int>(type: "int", nullable: true),
                    CustomerId = table.Column<int>(type: "int", nullable: true),
                    ApplicationName = table.Column<string>(type: "nvarchar(200)", maxLength: 200, nullable: true),
                    FinishedDate = table.Column<DateTime>(type: "date", nullable: true),
                    FinalizationDate = table.Column<DateTime>(type: "date", nullable: true),
                    ReturnDate = table.Column<DateTime>(type: "date", nullable: true),
                    CaseType = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    CaseState = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    DoItemMemo = table.Column<string>(type: "nvarchar(500)", maxLength: 500, nullable: true),
                    DoItemState = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    CaseName = table.Column<string>(type: "nvarchar(500)", maxLength: 500, nullable: true),
                    CustomerLimitDate = table.Column<DateTime>(type: "date", nullable: true),
                    EntrustingDate = table.Column<DateTime>(type: "date", nullable: true),
                    InternalDate = table.Column<DateTime>(type: "date", nullable: true),
                    FirstDraftDate = table.Column<DateTime>(type: "date", nullable: true),
                    OverDueMemo = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true),
                    BasePoint = table.Column<decimal>(type: "numeric(18,2)", nullable: true),
                    status = table.Column<int>(type: "int", nullable: true),
                    StaffId = table.Column<int>(type: "int", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_PerformanceItem", x => x.Id);
                    table.ForeignKey(
                        name: "FK_PerformanceItem_Customer",
                        column: x => x.CustomerId,
                        principalTable: "Customer",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Restrict);
                    table.ForeignKey(
                        name: "FK_PerformanceItem_Reviewer",
                        column: x => x.ReviewerId,
                        principalTable: "Staff",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Restrict);
                    table.ForeignKey(
                        name: "FK_PerformanceItem_Staff",
                        column: x => x.PreOAStaffId,
                        principalTable: "Staff",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Restrict);
                    table.ForeignKey(
                        name: "FK_PerformanceItem_Staff_StaffId",
                        column: x => x.StaffId,
                        principalTable: "Staff",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Restrict);
                });

            migrationBuilder.CreateTable(
                name: "ItemStaff",
                columns: table => new
                {
                    ItemId = table.Column<int>(type: "int", nullable: false),
                    DoPersonId = table.Column<int>(type: "int", nullable: false),
                    PerformancePoint = table.Column<double>(type: "float", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_ItemStaff", x => new { x.ItemId, x.DoPersonId });
                    table.ForeignKey(
                        name: "FK_ItemStaff_PerformanceItem",
                        column: x => x.ItemId,
                        principalTable: "PerformanceItem",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Restrict);
                    table.ForeignKey(
                        name: "FK_ItemStaff_Staff",
                        column: x => x.DoPersonId,
                        principalTable: "Staff",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Restrict);
                });

            migrationBuilder.InsertData(
                table: "StaffGrade",
                columns: new[] { "Id", "Coefficient", "Grade" },
                values: new object[,]
                {
                    { 1, 1.2, "S级" },
                    { 2, 1.1000000000000001, "A3级" },
                    { 3, 1.1000000000000001, "A2级" },
                    { 4, 1.1000000000000001, "A1级" },
                    { 5, 1.0, "B3级" },
                    { 6, 1.0, "B2级" },
                    { 7, 0.90000000000000002, "B1级" },
                    { 8, 0.90000000000000002, "C3级" },
                    { 9, 0.69999999999999996, "C2级" },
                    { 10, 0.69999999999999996, "C1级" },
                    { 11, 0.59999999999999998, "D3级" },
                    { 12, 0.59999999999999998, "D2级" },
                    { 13, 0.5, "D1级" }
                });

            migrationBuilder.InsertData(
                table: "VerifyCoefficient",
                columns: new[] { "CheckerId", "DoPersonId", "Coefficient" },
                values: new object[,]
                {
                    { 2, 5, 0.20000000000000001 },
                    { 2, 13, 0.5 },
                    { 4, 12, 0.40000000000000002 },
                    { 3, 12, 0.40000000000000002 },
                    { 2, 12, 0.40000000000000002 },
                    { 4, 11, 0.40000000000000002 },
                    { 3, 11, 0.40000000000000002 },
                    { 2, 11, 0.40000000000000002 },
                    { 4, 10, 0.29999999999999999 },
                    { 3, 10, 0.29999999999999999 },
                    { 2, 10, 0.29999999999999999 },
                    { 4, 9, 0.29999999999999999 },
                    { 3, 13, 0.5 },
                    { 3, 9, 0.29999999999999999 },
                    { 4, 8, 0.20000000000000001 },
                    { 3, 8, 0.20000000000000001 },
                    { 2, 8, 0.20000000000000001 },
                    { 4, 7, 0.20000000000000001 },
                    { 3, 7, 0.20000000000000001 },
                    { 2, 7, 0.20000000000000001 },
                    { 4, 6, 0.20000000000000001 },
                    { 3, 6, 0.20000000000000001 },
                    { 2, 6, 0.20000000000000001 },
                    { 4, 5, 0.20000000000000001 },
                    { 3, 5, 0.20000000000000001 },
                    { 2, 9, 0.29999999999999999 },
                    { 4, 13, 0.5 }
                });

            migrationBuilder.CreateIndex(
                name: "IX_Customer_ResponseManId",
                table: "Customer",
                column: "ResponseManId");

            migrationBuilder.CreateIndex(
                name: "IX_ItemStaff_DoPersonId",
                table: "ItemStaff",
                column: "DoPersonId");

            migrationBuilder.CreateIndex(
                name: "IX_PerformanceItem_CustomerId",
                table: "PerformanceItem",
                column: "CustomerId");

            migrationBuilder.CreateIndex(
                name: "IX_PerformanceItem_PreOAStaffId",
                table: "PerformanceItem",
                column: "PreOAStaffId");

            migrationBuilder.CreateIndex(
                name: "IX_PerformanceItem_ReviewerId",
                table: "PerformanceItem",
                column: "ReviewerId");

            migrationBuilder.CreateIndex(
                name: "IX_PerformanceItem_StaffId",
                table: "PerformanceItem",
                column: "StaffId");

            migrationBuilder.CreateIndex(
                name: "IX_Staff_StaffGradeId",
                table: "Staff",
                column: "StaffGradeId");

            migrationBuilder.CreateIndex(
                name: "IX_VerifyCoefficient_DoPersonId",
                table: "VerifyCoefficient",
                column: "DoPersonId");
        }

        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropTable(
                name: "ItemStaff");

            migrationBuilder.DropTable(
                name: "VerifyCoefficient");

            migrationBuilder.DropTable(
                name: "PerformanceItem");

            migrationBuilder.DropTable(
                name: "Customer");

            migrationBuilder.DropTable(
                name: "Staff");

            migrationBuilder.DropTable(
                name: "StaffGrade");
        }
    }
}