using System; using Microsoft.EntityFrameworkCore.Migrations; namespace Edge.Core.Database.Migrations { public partial class InitialCreate : Migration { protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.CreateTable( name: "FuelPointReservationModels", columns: table => new { Id = table.Column(nullable: false) .Annotation("Sqlite:Autoincrement", true), FuelPointId = table.Column(nullable: false), ReservedByFdcClientId = table.Column(nullable: false), ReservingTime = table.Column(nullable: false) }, constraints: table => { table.PrimaryKey("PK_FuelPointReservationModels", x => x.Id); }); migrationBuilder.CreateTable( name: "FuelPriceChanges", columns: table => new { Id = table.Column(nullable: false) .Annotation("Sqlite:Autoincrement", true), PumpId = table.Column(nullable: false), LogicalNozzleId = table.Column(nullable: false), NewPriceWithoutDecimal = table.Column(nullable: false), StartTime = table.Column(nullable: false), FinishTime = table.Column(nullable: true) }, constraints: table => { table.PrimaryKey("PK_FuelPriceChanges", x => x.Id); }); migrationBuilder.CreateTable( name: "PumpTransactionModels", columns: table => new { ReleaseToken = table.Column(nullable: false) .Annotation("Sqlite:Autoincrement", true), PumpId = table.Column(nullable: false), LogicalNozzleId = table.Column(nullable: false), TransactionSeqNumberFromPhysicalPump = table.Column(nullable: true), State = table.Column(nullable: false), ProductBarcode = table.Column(nullable: true), UnitPrice = table.Column(nullable: false), Amount = table.Column(nullable: false), Volumn = table.Column(nullable: false), LockedByFdcClientId = table.Column(nullable: true), LockedTime = table.Column(nullable: true), AuthorizedByFdcClientId = table.Column(nullable: true), AuthorizedTime = table.Column(nullable: true), PaidByFdcClientId = table.Column(nullable: true), PaidTime = table.Column(nullable: true), SaleStartTime = table.Column(nullable: true), SaleEndTime = table.Column(nullable: true), AmountTotalizer = table.Column(nullable: false), VolumeTotalizer = table.Column(nullable: false) }, constraints: table => { table.PrimaryKey("PK_PumpTransactionModels", x => x.ReleaseToken); }); } protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropTable( name: "FuelPointReservationModels"); migrationBuilder.DropTable( name: "FuelPriceChanges"); migrationBuilder.DropTable( name: "PumpTransactionModels"); } } }