using System;
using Microsoft.EntityFrameworkCore.Migrations;

#nullable disable

namespace wtmProject.DataAccess.Migrations
{
    public partial class hmr2024071501 : Migration
    {
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.CreateTable(
                name: "WTM_CONTRACT_IMPORT_TEMP",
                columns: table => new
                {
                    ID = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
                    TenantCode = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    ContractCode = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    ContractName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    Year = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    ERPCode = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    ERPName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    NUM = table.Column<int>(type: "int", nullable: false),
                    CustomName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    ProjectType = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    CustomType = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    SignDate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    ContractAmount = table.Column<decimal>(type: "decimal(18,2)", nullable: true),
                    ProjectManage = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    MarkManage = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    FirstBillingAmount = table.Column<decimal>(type: "decimal(18,2)", nullable: true),
                    FirstBillingDate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    FirstReceivedAmount = table.Column<decimal>(type: "decimal(18,2)", nullable: true),
                    FirstReceivedDate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    SecondBillingAmount = table.Column<decimal>(type: "decimal(18,2)", nullable: true),
                    SecondBillingDate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    SecondReceivedAmount = table.Column<decimal>(type: "decimal(18,2)", nullable: true),
                    SecondReceivedDate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    ThreeBillingAmount = table.Column<decimal>(type: "decimal(18,2)", nullable: true),
                    ThreeBillingDate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    ThreeReceivedAmount = table.Column<decimal>(type: "decimal(18,2)", nullable: true),
                    ThreeReceivedDate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    FourthBillingAmount = table.Column<decimal>(type: "decimal(18,2)", nullable: true),
                    FourthBillingDate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    FourthReceivedAmount = table.Column<decimal>(type: "decimal(18,2)", nullable: true),
                    FourthReceivedDate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    FifthBillingAmount = table.Column<decimal>(type: "decimal(18,2)", nullable: true),
                    FifthBillingDate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    FifthReceivedAmount = table.Column<decimal>(type: "decimal(18,2)", nullable: true),
                    FifthReceivedDate = table.Column<DateTime>(type: "datetime2", nullable: true),
                    CreateTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    CreateBy = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                    UpdateTime = table.Column<DateTime>(type: "datetime2", nullable: true),
                    UpdateBy = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_WTM_CONTRACT_IMPORT_TEMP", x => x.ID);
                });
        }

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