StaffPerformance/wispro.sp.api/Migrations/20211104013549_add-appealDB.cs

using System;
using Microsoft.EntityFrameworkCore.Migrations;

namespace wispro.sp.api.Migrations
{
    public partial class addappealDB : Migration
    {
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.CreateTable(
                name: "AppealType",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Name = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    CanDoExpress = table.Column<string>(type: "nvarchar(500)", maxLength: 500, nullable: true),
                    ReviewerExpress = table.Column<string>(type: "nvarchar(500)", maxLength: 500, nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_AppealType", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "BasePointRule",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    Rule = table.Column<string>(type: "nvarchar(1000)", maxLength: 1000, nullable: true),
                    PointExpress = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true),
                    Priority = table.Column<int>(type: "int", nullable: false),
                    Type = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_BasePointRule", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "CalMonth",
                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),
                    status = table.Column<int>(type: "int", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_CalMonth", x => x.Id);
                });

            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: "InputField",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    FieldName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    FieldType = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    FieldValue = table.Column<string>(type: "nvarchar(500)", maxLength: 500, nullable: true),
                    MapObjectField = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    AppealTypeId = table.Column<int>(type: "int", nullable: false),
                    AppealState = table.Column<int>(type: "int", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_InputField", x => x.Id);
                    table.ForeignKey(
                        name: "FK_InputField_AppealType_AppealTypeId",
                        column: x => x.AppealTypeId,
                        principalTable: "AppealType",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "Staff",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    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),
                    Sex = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Tel = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Mobile = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    IsOnJob = table.Column<bool>(type: "bit", 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: true),
                    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),
                    Mail = table.Column<string>(type: "nvarchar(max)", 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: "AppealRecord",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    CreaterId = table.Column<int>(type: "int", nullable: false),
                    CreateTime = table.Column<DateTime>(type: "datetime2", nullable: false),
                    Reason = table.Column<string>(type: "nvarchar(500)", maxLength: 500, nullable: true),
                    State = table.Column<int>(type: "int", nullable: false),
                    ReviewerId = table.Column<int>(type: "int", nullable: false),
                    ReviewerMemo = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    ReviewTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    TypeId = table.Column<int>(type: "int", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_AppealRecord", x => x.Id);
                    table.ForeignKey(
                        name: "FK_AppealRecord_AppealType_TypeId",
                        column: x => x.TypeId,
                        principalTable: "AppealType",
                        principalColumn: "Id");
                    table.ForeignKey(
                        name: "FK_AppealRecord_Staff_CreaterId",
                        column: x => x.CreaterId,
                        principalTable: "Staff",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_AppealRecord_Staff_ReviewerId",
                        column: x => x.ReviewerId,
                        principalTable: "Staff",
                        principalColumn: "Id");
                });

            migrationBuilder.CreateTable(
                name: "Customer",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    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: "Message",
                columns: table => new
                {
                    Id = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
                    MessageInfo = table.Column<string>(type: "nvarchar(500)", maxLength: 500, nullable: true),
                    Type = table.Column<int>(type: "int", nullable: false),
                    FromId = table.Column<int>(type: "int", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Message", x => x.Id);
                    table.ForeignKey(
                        name: "FK_From_Staff",
                        column: x => x.FromId,
                        principalTable: "Staff",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Restrict);
                });

            migrationBuilder.CreateTable(
                name: "AttachFile",
                columns: table => new
                {
                    Id = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
                    Name = table.Column<string>(type: "nvarchar(200)", maxLength: 200, nullable: true),
                    SavePath = table.Column<string>(type: "nvarchar(200)", maxLength: 200, nullable: true),
                    UploadUserId = table.Column<int>(type: "int", nullable: false),
                    AppealRecordId = table.Column<int>(type: "int", nullable: false),
                    AppealRecordId1 = table.Column<int>(type: "int", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_AttachFile", x => x.Id);
                    table.ForeignKey(
                        name: "FK_AttachFile_AppealRecord",
                        column: x => x.AppealRecordId,
                        principalTable: "AppealRecord",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_AttachFile_AppealRecord_AppealRecordId1",
                        column: x => x.AppealRecordId1,
                        principalTable: "AppealRecord",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Restrict);
                    table.ForeignKey(
                        name: "FK_AttachFile_UpdateUser",
                        column: x => x.UploadUserId,
                        principalTable: "Staff",
                        principalColumn: "Id");
                });

            migrationBuilder.CreateTable(
                name: "InputFieldValue",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    InputFieldId = table.Column<int>(type: "int", nullable: false),
                    Value = table.Column<string>(type: "nvarchar(500)", maxLength: 500, nullable: true),
                    AppealRecordId = table.Column<int>(type: "int", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_InputFieldValue", x => x.Id);
                    table.ForeignKey(
                        name: "FK_InputFieldValue_AppealRecord_AppealRecordId",
                        column: x => x.AppealRecordId,
                        principalTable: "AppealRecord",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_InputFieldValue_InputField_InputFieldId",
                        column: x => x.InputFieldId,
                        principalTable: "InputField",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateTable(
                name: "PerformanceItem",
                columns: table => new
                {
                    Id = table.Column<int>(type: "int", nullable: false)
                        .Annotation("SqlServer:Identity", "1, 1"),
                    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),
                    CaseMemo = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    WordCount = table.Column<int>(type: "int", nullable: true),
                    ReturnCasseNo = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Type = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    CalMonthId = table.Column<int>(type: "int", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_PerformanceItem", x => x.Id);
                    table.ForeignKey(
                        name: "FK_PerformanceItem_CalMonth",
                        column: x => x.CalMonthId,
                        principalTable: "CalMonth",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                    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);
                });

            migrationBuilder.CreateTable(
                name: "MessageReadRecord",
                columns: table => new
                {
                    MessageId = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
                    StaffId = table.Column<int>(type: "int", nullable: false),
                    isReaded = table.Column<bool>(type: "bit", nullable: false),
                    MessageId1 = table.Column<Guid>(type: "uniqueidentifier", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_MessageReadRecord", x => new { x.MessageId, x.StaffId });
                    table.ForeignKey(
                        name: "FK_MessageReadRecord_Message",
                        column: x => x.MessageId,
                        principalTable: "Message",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Restrict);
                    table.ForeignKey(
                        name: "FK_MessageReadRecord_Message_MessageId1",
                        column: x => x.MessageId1,
                        principalTable: "Message",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Restrict);
                    table.ForeignKey(
                        name: "FK_MessageReadRecord_Staff",
                        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: true)
                },
                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.CreateTable(
                name: "MessagePerformanceItems",
                columns: table => new
                {
                    MessageId = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
                    ItemId = table.Column<int>(type: "int", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_MessagePerformanceItems", x => new { x.ItemId, x.MessageId });
                    table.ForeignKey(
                        name: "FK_MessagePerformanceItem_Item",
                        column: x => x.ItemId,
                        principalTable: "PerformanceItem",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_MessagePerformanceItem_Message",
                        column: x => x.MessageId,
                        principalTable: "Message",
                        principalColumn: "Id",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.InsertData(
                table: "BasePointRule",
                columns: new[] { "Id", "PointExpress", "Priority", "Rule", "Type" },
                values: new object[,]
                {
                    { 1, "0.2", 1, "p.ApplicationType==\"外观设计\"", "新申请" },
                    { 97, "0.3", 97, "p.DoItem==\"翻译校核\" && p.DoItemCoefficient==\"形式\" && p.AgentFeedbackMemo==\"内-外\"", "其它" },
                    { 96, "0.5", 96, "p.DoItem==\"翻译校核\" && p.DoItemCoefficient==\"实质\" && p.AgentFeedbackMemo==\"外-内\"", "其它" },
                    { 95, "0.7", 95, "p.DoItem==\"翻译校核\" && p.DoItemCoefficient==\"实质\" && p.AgentFeedbackMemo==\"内-外\"", "其它" },
                    { 94, "0.2", 94, "p.DoItem==\"发明一次OA授权\" && p.ApplicationType==\"发明\"", "一次OA授权" },
                    { 93, "0.0", 93, "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PCTCN\") &&  (p.CaseStage==\"三通\" || p.CaseStage==\"四通\" || p.CaseStage==\"五通\")", "OA" },
                    { 92, "0.0", 92, "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PACN\") &&  (p.CaseStage==\"三通\" || p.CaseStage==\"四通\" || p.CaseStage==\"五通\")", "OA" },
                    { 91, "0.2", 91, "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" &&  p.CaseNo.StartsWith(\"PCTCN\") && p.CaseStage==\"二通\"", "OA" },
                    { 90, "0.2", 90, "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" &&  p.CaseNo.StartsWith(\"PACN\") && p.CaseStage==\"二通\"", "OA" },
                    { 89, "0.2", 89, "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" &&  p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PCTCN\") && p.CaseStage==\"一通\"", "OA" },
                    { 88, "0.5", 88, "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" &&  p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PCTCN\")  && p.CaseStage==\"一通\"", "OA" },
                    { 87, "0.3", 87, "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" &&  p.DoItemCoefficient==\"非实质\" && p.CaseNo.StartsWith(\"PCTCN\") && p.CaseStage==\"一通\"", "OA" },
                    { 86, "0.2", 86, "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" &&  p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PACN\") && p.CaseStage==\"一通\"", "OA" },
                    { 85, "0.5", 85, "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" &&  p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PACN\")  && p.CaseStage==\"一通\"", "OA" },
                    { 84, "0.3", 84, "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" &&  p.DoItemCoefficient==\"非实质\" && p.CaseNo.StartsWith(\"PACN\") && p.CaseStage==\"一通\"", "OA" },
                    { 83, "0.2", 83, "p.DoItem==\"意见陈述\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PACN\") && p.CaseStage==\"复审\"", "OA" },
                    { 82, "0.5", 82, "p.DoItem==\"请求复审\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PACN\")", "OA" },
                    { 81, "0.2", 81, "p.DoItem==\"申復\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PATW\")", "OA" },
                    { 80, "0.5", 80, "p.DoItem==\"申復\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PATW\")", "OA" },
                    { 79, "0.2", 79, "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PAIN\")", "OA" },
                    { 78, "0.2", 78, "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PAGB\")", "OA" },
                    { 77, "0.2", 77, "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PAEPO\")", "OA" },
                    { 76, "0.3", 76, "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PADE\")", "OA" },
                    { 75, "0.2", 75, "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PAAU\")", "OA" },
                    { 74, "1.5", 74, "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PAIN\")", "OA" },
                    { 72, "1.5", 72, "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PAEPO\")", "OA" },
                    { 71, "1.6", 71, "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PADE\")", "OA" },
                    { 70, "1.5", 70, "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PAAU\")", "OA" },
                    { 69, "0.2", 69, "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PAUS\")", "OA" },
                    { 68, "1.5", 68, "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PAUS\")", "OA" },
                    { 98, "0.2", 98, "p.DoItem==\"翻译校核\" && p.DoItemCoefficient==\"形式\" && p.AgentFeedbackMemo==\"外-内\"", "其它" },
                    { 67, "1.5", 67, "p.DoItem==\"口审评估\" && p.DoItemCoefficient==\"实质\"", "OA" },
                    { 99, "0.1", 99, "p.AgentFeedbackMemo==\"检索结案\"", "其它" },
                    { 101, "0.2", 101, "p.DoItem.Contains(\"补正\")  && p.CaseNo.StartsWith(\"PAAU\")", "其它" },
                    { 130, "0.0", 130, "p.AgentFeedbackMemo==\"已核算绩效\"", "其它" },
                    { 129, "p.WordCount/1000*0.18", 129, "p.DoItem==\"翻译\") && p.AgentFeedbackMemo==\"中-德\"", "其它" },
                    { 128, "p.WordCount/1000*0.16", 128, "p.DoItem==\"翻译\") && p.AgentFeedbackMemo==\"中-英\"", "其它" },
                    { 127, "p.WordCount/1000*0.1", 127, "p.DoItem==\"翻译\") && p.AgentFeedbackMemo==\"英-中\"", "其它" },
                    { 126, "0.0", 126, "p.DoItem==\"请求优先审查\"", "其它" },
                    { 125, "0.0", 125, "p.DoItem==\"提交ids\"", "其它" },
                    { 124, "0.2", 124, "p.ApplicationType==\"外观设计\"", "其它" },
                    { 123, "0.0", 123, "p.DoItem==\"专利挖掘与布局\"", "其它" }
                });

            migrationBuilder.InsertData(
                table: "BasePointRule",
                columns: new[] { "Id", "PointExpress", "Priority", "Rule", "Type" },
                values: new object[,]
                {
                    { 122, "0.0", 122, "p.DoItem==\"知识点总结\"", "其它" },
                    { 121, "0.0", 121, "p.DoItem==\"询问放弃或复审\"", "其它" },
                    { 120, "0.1", 120, "p.DoItem==\"提交ids\"", "其它" },
                    { 119, "0.0", 119, "p.DoItem==\"技术确认\"", "其它" },
                    { 118, "0.0", 118, "p.DoItem==\"绘图\"", "其它" },
                    { 117, "0.2", 117, "p.DoItem==\"分案评估+分案\"", "其它" },
                    { 116, "0.1", 116, "p.DoItem==\"分案评估\"", "其它" },
                    { 115, "0.2", 115, "p.DoItem==\"电询\"  && p.CaseNo.StartsWith(\"PAUS\")", "其它" },
                    { 114, "0.2", 114, "p.DoItem==\"电询\"  && p.CaseNo.StartsWith(\"PAEPO\") ", "其它" },
                    { 113, "0.0", 113, "p.DoItem==\"电询\"  && p.CaseNo.StartsWith(\"PACN\")", "其它" },
                    { 112, "0.1", 112, "p.DoItem==\"PPH\"", "其它" },
                    { 111, "0.2", 111, "p.DoItem==\"OA答辩校核\"", "其它" },
                    { 110, "0.2", 110, "p.DoItem==\"Election Action\"", "其它" },
                    { 109, "0.2", 109, "p.DoItem.Contains(\"补正\")  && p.CaseNo.StartsWith(\"PAUS\")", "其它" },
                    { 108, "0.2", 108, "p.DoItem.Contains(\"补正\")  && p.CaseNo.StartsWith(\"PAIN\")", "其它" },
                    { 107, "0.2", 107, "p.DoItem.Contains(\"补正\")  && p.CaseNo.StartsWith(\"PAGB\")", "其它" },
                    { 106, "0.2", 106, "p.DoItem.Contains(\"补正\")  && p.CaseNo.StartsWith(\"PAEPO\")", "其它" },
                    { 105, "0.2", 105, "p.DoItem.Contains(\"补正\")  && p.CaseNo.StartsWith(\"PADE\")", "其它" },
                    { 104, "0.0", 104, "p.DoItem.Contains(\"补正\")  && p.CaseNo.StartsWith(\"WOCN\")", "其它" },
                    { 103, "0.0", 103, "p.DoItem.Contains(\"补正\")  && p.CaseNo.StartsWith(\"PCTCN\")", "其它" },
                    { 102, "0.0", 102, "p.DoItem.Contains(\"补正\")  && p.CaseNo.StartsWith(\"PACN\")", "其它" },
                    { 100, "0.0", 100, "p.DoItem==\"内部检索\"", "其它" },
                    { 66, "0.2", 66, "p.DoItem==\"口审评估\" && p.DoItemCoefficient==\"非实质\"", "OA" },
                    { 73, "1.5", 73, "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PAGB\")", "OA" },
                    { 64, "1.5", 64, "p.DoItem==\"欧洲案答辩\" && p.DoItemCoefficient==\"实质\"", "OA" },
                    { 30, "0.7", 29, "p.DoItem==\"新申请\" && p.ApplicationType==\"实用新型\" &&  p.CaseNo.StartsWith(\"PACN\")", "新申请" },
                    { 29, "1.0", 30, "p.DoItem==\"新申请\" && p.ApplicationType==\"实用新型\" &&  p.CaseNo.StartsWith(\"PACN\") && p.Customer.Name.Contains(\"OPPO\")", "新申请" },
                    { 28, "1.0", 28, "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PACN\")", "新申请" },
                    { 27, "0.1", 27, "p.DoItem==\"新申请\" && p.ApplicationType==\"实用新型\" &&  p.CaseNo.StartsWith(\"PACN\") && p.CaseNo.EndsWith(\"-TS\")", "新申请" },
                    { 65, "0.2", 65, "p.DoItem==\"欧洲案答辩\" && p.DoItemCoefficient==\"形式\"", "OA" },
                    { 25, "0.5", 25, "p.CaseNo.StartsWith(\"PAUS\") && (p.CaseNo.EndsWith(\"-同套\") || p.CaseNo.EndsWith(\"CA\") || p.CaseNo.EndsWith(\"CIP\") || p.CaseNo.EndsWith(\"分案\")) ", "新申请" },
                    { 24, "0.3", 24, "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" &&  p.CaseNo.StartsWith(\"PACN\") && p.CaseNo.EndsWith(\"-分案\")", "新申请" },
                    { 23, "1.8", 23, "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" &&  p.CaseNo.StartsWith(\"PAEPO\")", "新申请" },
                    { 22, "0.2", 22, "p.DoItem==\"新申请\" && p.CaseNo.StartsWith(\"PATW\") && p.AgentFeedbackMemo==\"大陆案转台湾案\"", "新申请" },
                    { 21, "1.0", 21, "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\"  && p.CaseNo.StartsWith(\"PACN\") && p.AgentFeedbackMemo==\"同套大陆+台湾\"", "新申请" },
                    { 20, "0.2", 20, "p.DoItem==\"新申请\" && p.CaseNo.StartsWith(\"PACN\") && p.AgentFeedbackMemo==\"台湾案转大陆案\"", "新申请" },
                    { 19, "0.1", 19, "p.DoItem==\"新申请\" && p.ApplicationType==\"实用新型\" && p.CaseNo.StartsWith(\"PATW\") && p.AgentFeedbackMemo==\"同套大陆+台湾\"", "新申请" },
                    { 18, "0.7", 18, "p.DoItem==\"新申请\" && p.ApplicationType==\"实用新型\" && p.CaseNo.StartsWith(\"PACN\") && p.AgentFeedbackMemo==\"同套大陆+台湾\"", "新申请" },
                    { 17, "0.1", 17, "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\"  && p.CaseNo.StartsWith(\"PATW\") && p.AgentFeedbackMemo==\"同套大陆+台湾\"", "新申请" },
                    { 16, "0.1", 16, "p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"转格式\"", "新申请" },
                    { 15, "1.5", 15, "p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"外-内首次申请\"", "新申请" },
                    { 14, "1.0", 14, "p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"首次中文案\"", "新申请" }
                });

            migrationBuilder.InsertData(
                table: "BasePointRule",
                columns: new[] { "Id", "PointExpress", "Priority", "Rule", "Type" },
                values: new object[,]
                {
                    { 13, "0.7", 13, "p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"涉外实质改权\"", "新申请" },
                    { 12, "0.5", 12, "p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"改权+改说明书\"", "新申请" },
                    { 11, "0.3", 11, "p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"改权\"", "新申请" },
                    { 10, "1.8", 10, "p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"PCT首次英文案\"", "新申请" },
                    { 9, "0.2", 9, "p.AgentFeedbackMemo==\"我方转格式、复核\"", "新申请" },
                    { 8, "0.0", 8, "p.AgentFeedbackMemo==\"我方代交\"", "新申请" },
                    { 7, "1.26", 7, "p.CaseNo.StartsWith(\"PAUS\")  && p.AgentFeedbackMemo==\"发文后客户原因取消申请，系统结案\"", "新申请" },
                    { 6, "1.33", 6, "p.CaseNo.StartsWith(\"PADE\")  && p.AgentFeedbackMemo==\"发文后客户原因取消申请，系统结案\"", "新申请" },
                    { 5, "0.7", 5, "p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PACN\") && p.AgentFeedbackMemo==\"发文后客户取消申请\"", "新申请" },
                    { 4, "0.49", 4, "p.ApplicationType==\"实用新型\" && p.CaseNo.StartsWith(\"PACN\") && p.AgentFeedbackMemo==\"发文后客户取消申请\"", "新申请" },
                    { 3, "0.0", 3, "p.AgentFeedbackMemo==\"撰写中客户取消申请\"", "新申请" },
                    { 2, "0.2", 2, "p.AgentFeedbackMemo==\"检索结案\"", "新申请" },
                    { 31, "1.9", 31, "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" &&  p.CaseNo.StartsWith(\"PADE\")", "新申请" },
                    { 32, "1.9", 32, "p.DoItem==\"新申请\" && p.ApplicationType==\"实用新型\" &&  p.CaseNo.StartsWith(\"PADE\")", "新申请" },
                    { 26, "1.0", 26, "p.DoItem==\"新申请\"  && p.ApplicationType==\"发明\" &&  p.CaseNo.StartsWith(\"PACN\") && p.CaseNo.EndsWith(\"-TS\")", "新申请" },
                    { 34, "1.8", 34, "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" &&  p.CaseNo.StartsWith(\"PAGB\")", "新申请" },
                    { 63, "0.2", 63, "p.DoItem==\"RCE\" && p.DoItemCoefficient==\"形式\"", "OA" },
                    { 62, "1.5", 62, "p.DoItem==\"RCE\" && p.DoItemCoefficient==\"实质\"", "OA" },
                    { 61, "0.2", 61, "p.DoItem==\"Non Final Action\" && p.DoItemCoefficient==\"形式\"", "OA" },
                    { 60, "1.5", 60, "p.DoItem==\"Non Final Action\" && p.DoItemCoefficient==\"实质\"", "OA" },
                    { 59, "0.1", 59, "p.DoItem==\"form 3-8（2）\" ||  p.DoItem==\"Form 3-8(2)\"", "OA" },
                    { 58, "0.1", 58, "p.DoItem==\"form 3\"", "OA" },
                    { 33, "0.2", 33, "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" &&  p.CaseNo.StartsWith(\"PAEPO\")", "新申请" },
                    { 56, "1.5", 56, "p.DoItem==\"Final Action\" && p.DoItemCoefficient==\"实质\"", "OA" },
                    { 55, "0.2", 55, "p.DoItem==\"Advisory Action\" && p.DoItemCoefficient==\"形式\"", "OA" },
                    { 54, "1.5", 54, "p.DoItem==\"Advisory Action\" && p.DoItemCoefficient==\"实质\"", "OA" },
                    { 53, "0.8", 53, "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.AgentFeedbackMemo==\"客户未提供答辩点，撰写英文报导函\"", "OA" },
                    { 52, "0.5", 52, "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.AgentFeedbackMemo==\"客户提供答辩点，撰写英文报导函\"", "OA" },
                    { 51, "0.2", 51, "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.DoItemCoefficient==\"形式\" && p.AgentFeedbackMemo==\"外所/他人首次转入OA\"", "OA" },
                    { 50, "0.5", 50, "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.DoItemCoefficient==\"实质\" && p.AgentFeedbackMemo==\"外所/他人首次转入OA\"", "OA" },
                    { 57, "0.2", 57, "p.DoItem==\"Final Action\" && p.DoItemCoefficient==\"形式\"", "OA" },
                    { 48, "0.35", 48, "p.DoItem==\"请求复审\" && p.ApplicationType==\"实用新型\"  && p.AgentFeedbackMemo==\"请款\"", "OA" },
                    { 49, "0.3", 49, "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.DoItemCoefficient==\"非实质\"  && p.AgentFeedbackMemo==\"外所/他人首次转入OA\"", "OA" },
                    { 35, "1.7", 36, "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" &&  p.CaseNo.StartsWith(\"PAUS\") && p.Customer.Name.Contains(\"OPPO\")", "新申请" },
                    { 36, "1.8", 35, "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" &&  p.CaseNo.StartsWith(\"PAUS\")", "新申请" },
                    { 37, "1.5", 37, "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" &&  p.CaseNo.StartsWith(\"PCTCN\")", "新申请" },
                    { 38, "0.0", 38, "(p.ApplicationType==\"实用新型\" || p.ApplicationType==\"发明\") && p.CaseNo.StartsWith(\"PACN\") && p.AgentFeedbackMemo==\"客户不进行答辩\"", "新申请" },
                    { 40, "p.WordCount/1000*0.16", 40, "p.DoItem==\"新申请\") && p.AgentFeedbackMemo==\"中-英\" && p.WordCount !=null", "新申请" },
                    { 39, "p.WordCount/1000*0.1", 39, "p.DoItem==\"新申请\") && p.AgentFeedbackMemo==\"英-中\" && p.WordCount !=null", "新申请" },
                    { 42, "0.1", 42, "p.AgentFeedbackMemo==\"涉外OA不答辩，发报导函结案\"", "OA" },
                    { 43, "0.2", 43, "p.ApplicationType==\"外观设计\"", "OA" },
                    { 44, "0.0", 44, "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"实用新型\"  && p.AgentFeedbackMemo==\"不请款\"", "OA" }
                });

            migrationBuilder.InsertData(
                table: "BasePointRule",
                columns: new[] { "Id", "PointExpress", "Priority", "Rule", "Type" },
                values: new object[,]
                {
                    { 45, "0.0", 45, "p.ApplicationType==\"实用新型\"  && p.DoItemCoefficient==\"实质\" && (p.CaseStage==\"三通\" || p.CaseStage==\"四通\" || p.CaseStage==\"五通\" || p.CaseStage==\"六通\" || p.CaseStage==\"七通\" || p.CaseStage==\"八通\") ", "OA" },
                    { 46, "0.14", 46, "p.ApplicationType==\"实用新型\"  && p.DoItemCoefficient==\"实质\" && p.CaseStage==\"二通\" && p.AgentFeedbackMemo==\"请款\"", "OA" },
                    { 47, "0.35", 47, "p.ApplicationType==\"实用新型\"  && p.DoItemCoefficient==\"实质\" && p.CaseStage==\"一通\" && p.AgentFeedbackMemo==\"请款\"", "OA" },
                    { 41, "p.WordCount/1000*0.18", 41, "p.DoItem==\"新申请\") && p.AgentFeedbackMemo==\"中-德\" && p.WordCount !=null", "新申请" }
                });

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

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

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

            migrationBuilder.CreateIndex(
                name: "IX_AppealRecord_CreaterId",
                table: "AppealRecord",
                column: "CreaterId");

            migrationBuilder.CreateIndex(
                name: "IX_AppealRecord_ReviewerId",
                table: "AppealRecord",
                column: "ReviewerId");

            migrationBuilder.CreateIndex(
                name: "IX_AppealRecord_TypeId",
                table: "AppealRecord",
                column: "TypeId");

            migrationBuilder.CreateIndex(
                name: "IX_AttachFile_AppealRecordId",
                table: "AttachFile",
                column: "AppealRecordId");

            migrationBuilder.CreateIndex(
                name: "IX_AttachFile_AppealRecordId1",
                table: "AttachFile",
                column: "AppealRecordId1");

            migrationBuilder.CreateIndex(
                name: "IX_AttachFile_UploadUserId",
                table: "AttachFile",
                column: "UploadUserId");

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

            migrationBuilder.CreateIndex(
                name: "IX_InputField_AppealTypeId",
                table: "InputField",
                column: "AppealTypeId");

            migrationBuilder.CreateIndex(
                name: "IX_InputFieldValue_AppealRecordId",
                table: "InputFieldValue",
                column: "AppealRecordId");

            migrationBuilder.CreateIndex(
                name: "IX_InputFieldValue_InputFieldId",
                table: "InputFieldValue",
                column: "InputFieldId");

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

            migrationBuilder.CreateIndex(
                name: "IX_Message_FromId",
                table: "Message",
                column: "FromId");

            migrationBuilder.CreateIndex(
                name: "IX_MessagePerformanceItems_MessageId",
                table: "MessagePerformanceItems",
                column: "MessageId");

            migrationBuilder.CreateIndex(
                name: "IX_MessageReadRecord_MessageId1",
                table: "MessageReadRecord",
                column: "MessageId1");

            migrationBuilder.CreateIndex(
                name: "IX_MessageReadRecord_StaffId",
                table: "MessageReadRecord",
                column: "StaffId");

            migrationBuilder.CreateIndex(
                name: "IX_PerformanceItem_CalMonthId",
                table: "PerformanceItem",
                column: "CalMonthId");

            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_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: "AttachFile");

            migrationBuilder.DropTable(
                name: "BasePointRule");

            migrationBuilder.DropTable(
                name: "InputFieldValue");

            migrationBuilder.DropTable(
                name: "ItemStaff");

            migrationBuilder.DropTable(
                name: "MessagePerformanceItems");

            migrationBuilder.DropTable(
                name: "MessageReadRecord");

            migrationBuilder.DropTable(
                name: "VerifyCoefficient");

            migrationBuilder.DropTable(
                name: "AppealRecord");

            migrationBuilder.DropTable(
                name: "InputField");

            migrationBuilder.DropTable(
                name: "PerformanceItem");

            migrationBuilder.DropTable(
                name: "Message");

            migrationBuilder.DropTable(
                name: "AppealType");

            migrationBuilder.DropTable(
                name: "CalMonth");

            migrationBuilder.DropTable(
                name: "Customer");

            migrationBuilder.DropTable(
                name: "Staff");

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