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(nullable: false) .Annotation("Sqlite:Autoincrement", true), Gid = table.Column(nullable: false), AccountSNo = table.Column(nullable: false), SNo = table.Column(nullable: false), AccountId = table.Column(nullable: true), AccountName = table.Column(nullable: true), Address = table.Column(nullable: true), PhoneNo = table.Column(nullable: true), AccountType = table.Column(nullable: false), Amount = table.Column(nullable: false), AmountType = table.Column(nullable: false), FuelNo = table.Column(nullable: true), Credit = table.Column(nullable: false), State = table.Column(nullable: false), AccountDate = table.Column(nullable: false), CertType = table.Column(nullable: true), CertNo = table.Column(nullable: true), RechargeTotal = table.Column(nullable: false), TMac = table.Column(nullable: false), WaitMalloc = table.Column(nullable: false), EnableSms = table.Column(nullable: false), UploadFlag = table.Column(nullable: false), VersionNo = table.Column(nullable: false), LastUpdate = table.Column(nullable: false), CommitFlag = table.Column(nullable: false), SyncFlag = table.Column(nullable: false) }, constraints: table => { table.PrimaryKey("PK_Account", x => x.Id); }); migrationBuilder.CreateTable( name: "AccountUpload", columns: table => new { Id = table.Column(nullable: false) .Annotation("Sqlite:Autoincrement", true), Gid = table.Column(nullable: false), AccountId = table.Column(nullable: false), Operation = table.Column(nullable: false), Status = table.Column(nullable: false), OperationTime = table.Column(nullable: false) }, constraints: table => { table.PrimaryKey("PK_AccountUpload", x => x.Id); }); migrationBuilder.CreateTable( name: "AddBlackCard", columns: table => new { Id = table.Column(nullable: false) .Annotation("Sqlite:Autoincrement", true), Gid = table.Column(nullable: false), CardNo = table.Column(nullable: true), DateTime = table.Column(nullable: false), AccountGid = table.Column(nullable: false), AccountId = table.Column(nullable: true), CardType = table.Column(nullable: false), DiscountNo = table.Column(nullable: false), Reason = table.Column(nullable: true), UploadFlag = table.Column(nullable: false), OperationType = table.Column(nullable: false), VersionNo = table.Column(nullable: false), LastUpdate = table.Column(nullable: false), CommitFlag = table.Column(nullable: false), SyncFlag = table.Column(nullable: false) }, constraints: table => { table.PrimaryKey("PK_AddBlackCard", x => x.Id); }); migrationBuilder.CreateTable( name: "Card", columns: table => new { Id = table.Column(nullable: false) .Annotation("Sqlite:Autoincrement", true), Gid = table.Column(nullable: false), CardSNo = table.Column(nullable: false), SNo = table.Column(nullable: false), CardId = table.Column(nullable: false), CardNo = table.Column(nullable: true), CTC = table.Column(nullable: false), CTCTime = table.Column(nullable: true), AccountGid = table.Column(nullable: false), AccountId = table.Column(nullable: true), UserNo = table.Column(nullable: true), Holder = table.Column(nullable: true), PhoneNo = table.Column(nullable: true), DMaxPay = table.Column(nullable: false), MMaxPay = table.Column(nullable: false), YMaxPay = table.Column(nullable: false), OnceMaxPay = table.Column(nullable: false), LimitCar = table.Column(nullable: false), CarNo = table.Column(nullable: true), Status = table.Column(nullable: false), UserPin = table.Column(nullable: true), OverDate = table.Column(nullable: false), KcDate = table.Column(nullable: false), OperatorNo = table.Column(nullable: true), LimitGood = table.Column(nullable: false), LimitOil = table.Column(nullable: true), CardType = table.Column(nullable: false), AuthStr = table.Column(nullable: true), TempCheckStr = table.Column(nullable: true), DiscountNo = table.Column(nullable: false), StartDate = table.Column(nullable: false), PreMalloc = table.Column(nullable: false), Balance = table.Column(nullable: false), RechargeTotal = table.Column(nullable: false), IntegralTotal = table.Column(nullable: false), CardClass = table.Column(nullable: false), TMac = table.Column(nullable: false), LimitTimes = table.Column(nullable: false), UploadFlag = table.Column(nullable: false), CTCFlag = table.Column(nullable: false), EnableSms = table.Column(nullable: false), VersionNo = table.Column(nullable: false), LastUpdate = table.Column(nullable: false), CommitFlag = table.Column(nullable: false), SyncFlag = table.Column(nullable: false) }, constraints: table => { table.PrimaryKey("PK_Card", x => x.Id); }); migrationBuilder.CreateTable( name: "CardUpload", columns: table => new { Id = table.Column(nullable: false) .Annotation("Sqlite:Autoincrement", true), Gid = table.Column(nullable: false), CardNo = table.Column(nullable: false), Operation = table.Column(nullable: false), Status = table.Column(nullable: false), OperationTime = table.Column(nullable: false) }, constraints: table => { table.PrimaryKey("PK_CardUpload", x => x.Id); }); migrationBuilder.CreateTable( name: "DataVersion", columns: table => new { Id = table.Column(nullable: false) .Annotation("Sqlite:Autoincrement", true), VersionNo = table.Column(nullable: false), LastUpdate = table.Column(nullable: false), CommitFlag = table.Column(nullable: false) }, constraints: table => { table.PrimaryKey("PK_DataVersion", x => x.Id); }); migrationBuilder.CreateTable( name: "DeleteBlackCard", columns: table => new { Id = table.Column(nullable: false) .Annotation("Sqlite:Autoincrement", true), Gid = table.Column(nullable: false), CardNo = table.Column(nullable: true), DateTime = table.Column(nullable: false), AccountGid = table.Column(nullable: false), AccountId = table.Column(nullable: true), CardType = table.Column(nullable: false), DiscountNo = table.Column(nullable: false), Reason = table.Column(nullable: true), UploadFlag = table.Column(nullable: false), OperationType = table.Column(nullable: false), VersionNo = table.Column(nullable: false), LastUpdate = table.Column(nullable: false), CommitFlag = table.Column(nullable: false), SyncFlag = table.Column(nullable: false) }, constraints: table => { table.PrimaryKey("PK_DeleteBlackCard", x => x.Id); }); migrationBuilder.CreateTable( name: "GrayTrade", columns: table => new { Id = table.Column(nullable: false) .Annotation("Sqlite:Autoincrement", true), Gid = table.Column(nullable: false), SNo = table.Column(nullable: false), PumpType = table.Column(nullable: false), CardNo = table.Column(nullable: true), PayModeId = table.Column(nullable: false), TrdType = table.Column(nullable: false), CommId = table.Column(nullable: true), Price = table.Column(nullable: false), Volume = table.Column(nullable: false), Amount = table.Column(nullable: false), PayAmount = table.Column(nullable: false), CardBalance = table.Column(nullable: false), CTC = table.Column(nullable: false), TtcTime = table.Column(nullable: false), TtcTimeEnd = table.Column(nullable: false), TTC = table.Column(nullable: false), SeqNo = table.Column(nullable: false), NozzleNo = table.Column(nullable: false), PumpNo = table.Column(nullable: false), PayTermId = table.Column(nullable: false), VolumeTotalizer = table.Column(nullable: false), DiscountNo = table.Column(nullable: false), PsamAsn = table.Column(nullable: true), PsamTac = table.Column(nullable: false), PsamTid = table.Column(nullable: true), PsamTtc = table.Column(nullable: false), Tac = table.Column(nullable: false), GMac = table.Column(nullable: false), TMac = table.Column(nullable: false), UploadFlag = table.Column(nullable: false), OperationType = table.Column(nullable: false), VersionNo = table.Column(nullable: false), LastUpdate = table.Column(nullable: false), CommitFlag = table.Column(nullable: false), SyncFlag = table.Column(nullable: false) }, constraints: table => { table.PrimaryKey("PK_GrayTrade", x => x.Id); }); migrationBuilder.CreateTable( name: "RechargeUpload", columns: table => new { Id = table.Column(nullable: false) .Annotation("Sqlite:Autoincrement", true), Gid = table.Column(nullable: false), AccountId = table.Column(nullable: true), CardNo = table.Column(nullable: true), Operation = table.Column(nullable: false), Status = table.Column(nullable: false), OperationTime = table.Column(nullable: false) }, constraints: table => { table.PrimaryKey("PK_RechargeUpload", x => x.Id); }); migrationBuilder.CreateTable( name: "TradeUpload", columns: table => new { Id = table.Column(nullable: false) .Annotation("Sqlite:Autoincrement", true), Gid = table.Column(nullable: false), Operation = table.Column(nullable: false), Status = table.Column(nullable: false), OperationTime = table.Column(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"); } } }