FCC/Applications/SpsDataCourier/Migrations/20201207011814_Initial.cs

using System;
using Microsoft.EntityFrameworkCore.Migrations;

namespace Dfs.WayneChina.SpsDataCourier.Migrations
{
    public partial class Initial : Migration
    {
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.CreateTable(
                name: "Account",
                columns: table => new
                {
                    Id = table.Column<ulong>(nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    Gid = table.Column<ulong>(nullable: false),
                    AccountSNo = table.Column<byte>(nullable: false),
                    SNo = table.Column<ushort>(nullable: false),
                    AccountId = table.Column<string>(nullable: true),
                    AccountName = table.Column<string>(nullable: true),
                    Address = table.Column<string>(nullable: true),
                    PhoneNo = table.Column<string>(nullable: true),
                    AccountType = table.Column<byte>(nullable: false),
                    Amount = table.Column<int>(nullable: false),
                    AmountType = table.Column<byte>(nullable: false),
                    FuelNo = table.Column<string>(nullable: true),
                    Credit = table.Column<uint>(nullable: false),
                    State = table.Column<byte>(nullable: false),
                    AccountDate = table.Column<DateTime>(nullable: false),
                    CertType = table.Column<string>(nullable: true),
                    CertNo = table.Column<string>(nullable: true),
                    RechargeTotal = table.Column<long>(nullable: false),
                    TMac = table.Column<uint>(nullable: false),
                    WaitMalloc = table.Column<uint>(nullable: false),
                    EnableSms = table.Column<byte>(nullable: false),
                    UploadFlag = table.Column<byte>(nullable: false),
                    VersionNo = table.Column<long>(nullable: false),
                    LastUpdate = table.Column<DateTime>(nullable: false),
                    CommitFlag = table.Column<byte>(nullable: false),
                    SyncFlag = table.Column<byte>(nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Account", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "AccountUpload",
                columns: table => new
                {
                    Id = table.Column<long>(nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    Gid = table.Column<long>(nullable: false),
                    AccountId = table.Column<string>(nullable: false),
                    Operation = table.Column<byte>(nullable: false),
                    Status = table.Column<int>(nullable: false),
                    OperationTime = table.Column<DateTime>(nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_AccountUpload", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "AddBlackCard",
                columns: table => new
                {
                    Id = table.Column<ulong>(nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    Gid = table.Column<ulong>(nullable: false),
                    CardNo = table.Column<string>(nullable: true),
                    DateTime = table.Column<DateTime>(nullable: false),
                    AccountGid = table.Column<ulong>(nullable: false),
                    AccountId = table.Column<string>(nullable: true),
                    CardType = table.Column<byte>(nullable: false),
                    DiscountNo = table.Column<ushort>(nullable: false),
                    Reason = table.Column<string>(nullable: true),
                    UploadFlag = table.Column<byte>(nullable: false),
                    OperationType = table.Column<byte>(nullable: false),
                    VersionNo = table.Column<long>(nullable: false),
                    LastUpdate = table.Column<DateTime>(nullable: false),
                    CommitFlag = table.Column<byte>(nullable: false),
                    SyncFlag = table.Column<byte>(nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_AddBlackCard", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "Card",
                columns: table => new
                {
                    Id = table.Column<ulong>(nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    Gid = table.Column<ulong>(nullable: false),
                    CardSNo = table.Column<byte>(nullable: false),
                    SNo = table.Column<ushort>(nullable: false),
                    CardId = table.Column<ulong>(nullable: false),
                    CardNo = table.Column<string>(nullable: true),
                    CTC = table.Column<ushort>(nullable: false),
                    CTCTime = table.Column<string>(nullable: true),
                    AccountGid = table.Column<ulong>(nullable: false),
                    AccountId = table.Column<string>(nullable: true),
                    UserNo = table.Column<string>(nullable: true),
                    Holder = table.Column<string>(nullable: true),
                    PhoneNo = table.Column<string>(nullable: true),
                    DMaxPay = table.Column<uint>(nullable: false),
                    MMaxPay = table.Column<uint>(nullable: false),
                    YMaxPay = table.Column<uint>(nullable: false),
                    OnceMaxPay = table.Column<uint>(nullable: false),
                    LimitCar = table.Column<byte>(nullable: false),
                    CarNo = table.Column<string>(nullable: true),
                    Status = table.Column<byte>(nullable: false),
                    UserPin = table.Column<string>(nullable: true),
                    OverDate = table.Column<DateTime>(nullable: false),
                    KcDate = table.Column<DateTime>(nullable: false),
                    OperatorNo = table.Column<string>(nullable: true),
                    LimitGood = table.Column<byte>(nullable: false),
                    LimitOil = table.Column<string>(nullable: true),
                    CardType = table.Column<byte>(nullable: false),
                    AuthStr = table.Column<string>(nullable: true),
                    TempCheckStr = table.Column<string>(nullable: true),
                    DiscountNo = table.Column<ushort>(nullable: false),
                    StartDate = table.Column<DateTime>(nullable: false),
                    PreMalloc = table.Column<uint>(nullable: false),
                    Balance = table.Column<uint>(nullable: false),
                    RechargeTotal = table.Column<long>(nullable: false),
                    IntegralTotal = table.Column<uint>(nullable: false),
                    CardClass = table.Column<byte>(nullable: false),
                    TMac = table.Column<uint>(nullable: false),
                    LimitTimes = table.Column<byte>(nullable: false),
                    UploadFlag = table.Column<byte>(nullable: false),
                    CTCFlag = table.Column<uint>(nullable: false),
                    EnableSms = table.Column<byte>(nullable: false),
                    VersionNo = table.Column<long>(nullable: false),
                    LastUpdate = table.Column<DateTime>(nullable: false),
                    CommitFlag = table.Column<byte>(nullable: false),
                    SyncFlag = table.Column<byte>(nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Card", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "CardUpload",
                columns: table => new
                {
                    Id = table.Column<long>(nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    Gid = table.Column<long>(nullable: false),
                    CardNo = table.Column<string>(nullable: false),
                    Operation = table.Column<byte>(nullable: false),
                    Status = table.Column<int>(nullable: false),
                    OperationTime = table.Column<DateTime>(nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_CardUpload", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "DataVersion",
                columns: table => new
                {
                    Id = table.Column<int>(nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    VersionNo = table.Column<long>(nullable: false),
                    LastUpdate = table.Column<DateTime>(nullable: false),
                    CommitFlag = table.Column<byte>(nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_DataVersion", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "DeleteBlackCard",
                columns: table => new
                {
                    Id = table.Column<ulong>(nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    Gid = table.Column<ulong>(nullable: false),
                    CardNo = table.Column<string>(nullable: true),
                    DateTime = table.Column<DateTime>(nullable: false),
                    AccountGid = table.Column<ulong>(nullable: false),
                    AccountId = table.Column<string>(nullable: true),
                    CardType = table.Column<byte>(nullable: false),
                    DiscountNo = table.Column<ushort>(nullable: false),
                    Reason = table.Column<string>(nullable: true),
                    UploadFlag = table.Column<byte>(nullable: false),
                    OperationType = table.Column<byte>(nullable: false),
                    VersionNo = table.Column<long>(nullable: false),
                    LastUpdate = table.Column<DateTime>(nullable: false),
                    CommitFlag = table.Column<byte>(nullable: false),
                    SyncFlag = table.Column<byte>(nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_DeleteBlackCard", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "GrayTrade",
                columns: table => new
                {
                    Id = table.Column<ulong>(nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    Gid = table.Column<ulong>(nullable: false),
                    SNo = table.Column<ushort>(nullable: false),
                    PumpType = table.Column<byte>(nullable: false),
                    CardNo = table.Column<string>(nullable: true),
                    PayModeId = table.Column<byte>(nullable: false),
                    TrdType = table.Column<byte>(nullable: false),
                    CommId = table.Column<string>(nullable: true),
                    Price = table.Column<uint>(nullable: false),
                    Volume = table.Column<uint>(nullable: false),
                    Amount = table.Column<uint>(nullable: false),
                    PayAmount = table.Column<uint>(nullable: false),
                    CardBalance = table.Column<uint>(nullable: false),
                    CTC = table.Column<ushort>(nullable: false),
                    TtcTime = table.Column<DateTime>(nullable: false),
                    TtcTimeEnd = table.Column<DateTime>(nullable: false),
                    TTC = table.Column<uint>(nullable: false),
                    SeqNo = table.Column<ushort>(nullable: false),
                    NozzleNo = table.Column<byte>(nullable: false),
                    PumpNo = table.Column<byte>(nullable: false),
                    PayTermId = table.Column<ulong>(nullable: false),
                    VolumeTotalizer = table.Column<ulong>(nullable: false),
                    DiscountNo = table.Column<ushort>(nullable: false),
                    PsamAsn = table.Column<string>(nullable: true),
                    PsamTac = table.Column<uint>(nullable: false),
                    PsamTid = table.Column<string>(nullable: true),
                    PsamTtc = table.Column<uint>(nullable: false),
                    Tac = table.Column<uint>(nullable: false),
                    GMac = table.Column<uint>(nullable: false),
                    TMac = table.Column<uint>(nullable: false),
                    UploadFlag = table.Column<byte>(nullable: false),
                    OperationType = table.Column<byte>(nullable: false),
                    VersionNo = table.Column<long>(nullable: false),
                    LastUpdate = table.Column<DateTime>(nullable: false),
                    CommitFlag = table.Column<byte>(nullable: false),
                    SyncFlag = table.Column<byte>(nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_GrayTrade", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "RechargeUpload",
                columns: table => new
                {
                    Id = table.Column<long>(nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    Gid = table.Column<long>(nullable: false),
                    AccountId = table.Column<string>(nullable: true),
                    CardNo = table.Column<string>(nullable: true),
                    Operation = table.Column<int>(nullable: false),
                    Status = table.Column<int>(nullable: false),
                    OperationTime = table.Column<DateTime>(nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_RechargeUpload", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "TradeUpload",
                columns: table => new
                {
                    Id = table.Column<long>(nullable: false)
                        .Annotation("Sqlite:Autoincrement", true),
                    Gid = table.Column<long>(nullable: false),
                    Operation = table.Column<int>(nullable: false),
                    Status = table.Column<int>(nullable: false),
                    OperationTime = table.Column<DateTime>(nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_TradeUpload", x => x.Id);
                });
        }

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

            migrationBuilder.DropTable(
                name: "AccountUpload");

            migrationBuilder.DropTable(
                name: "AddBlackCard");

            migrationBuilder.DropTable(
                name: "Card");

            migrationBuilder.DropTable(
                name: "CardUpload");

            migrationBuilder.DropTable(
                name: "DataVersion");

            migrationBuilder.DropTable(
                name: "DeleteBlackCard");

            migrationBuilder.DropTable(
                name: "GrayTrade");

            migrationBuilder.DropTable(
                name: "RechargeUpload");

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