using System; using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace gehGassi.Persistence.Migrations { /// public partial class ComplaintsAdded : Migration { /// protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.CreateTable( name: "WalkComplaints", columns: table => new { Id = table.Column(type: "nvarchar(128)", maxLength: 128, nullable: false), WalkId = table.Column(type: "nvarchar(128)", maxLength: 128, nullable: false), Source = table.Column(type: "int", nullable: false), Type = table.Column(type: "int", nullable: false), Message = table.Column(type: "nvarchar(1000)", maxLength: 1000, nullable: false), Status = table.Column(type: "int", nullable: false), UserName = table.Column(type: "nvarchar(256)", maxLength: 256, nullable: true), Comment = table.Column(type: "nvarchar(max)", nullable: true), Resolved = table.Column(type: "datetimeoffset", nullable: true), Created = table.Column(type: "datetimeoffset", nullable: false), Index = table.Column(type: "bigint", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), Version = table.Column(type: "rowversion", rowVersion: true, nullable: true), UpdatedAt = table.Column(type: "datetimeoffset", nullable: false), Deleted = table.Column(type: "bit", nullable: false) }, constraints: table => { table.PrimaryKey("PK_WalkComplaints", x => x.Id); table.ForeignKey( name: "FK_WalkComplaints_Walks_WalkId", column: x => x.WalkId, principalTable: "Walks", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateIndex( name: "IX_WalkComplaints_Index", table: "WalkComplaints", column: "Index"); migrationBuilder.CreateIndex( name: "IX_WalkComplaints_WalkId", table: "WalkComplaints", column: "WalkId"); } /// protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropTable( name: "WalkComplaints"); } } }