using Microsoft.EntityFrameworkCore.Migrations; #nullable disable #pragma warning disable CA1814 // Prefer jagged arrays over multidimensional namespace ServerManagement.Migrations { /// public partial class InitialMigration : Migration { /// protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.CreateTable( name: "Servers", columns: table => new { Id = table.Column(type: "INTEGER", nullable: false) .Annotation("Sqlite:Autoincrement", true), IsOnline = table.Column(type: "INTEGER", nullable: false), Name = table.Column(type: "TEXT", nullable: false), City = table.Column(type: "TEXT", nullable: false) }, constraints: table => { table.PrimaryKey("PK_Servers", x => x.Id); }); migrationBuilder.InsertData( table: "Servers", columns: new[] { "Id", "City", "IsOnline", "Name" }, values: new object[,] { { 1, "Eindhoven", true, "Server1" }, { 2, "Eindhoven", true, "Server2" }, { 3, "Eindhoven", false, "Server3" }, { 4, "Eindhoven", true, "Server4" }, { 5, "Helmond", true, "Server5" }, { 6, "Helmond", false, "Server6" }, { 7, "Helmond", true, "Server7" }, { 8, "Oosterhout", true, "Server8" }, { 9, "Oosterhout", true, "Server9" }, { 10, "Roosendaal", false, "Server10" }, { 11, "Roosendaal", false, "Server11" }, { 12, "Deurne", false, "Server12" }, { 13, "Deurne", true, "Server13" } }); } /// protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropTable( name: "Servers"); } } }