using System; using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace Data.SeaHavenIndustries.Migrations { /// public partial class SH325_PendingTeamMember : Migration { /// protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.AddColumn( name: "PendingRegistration", table: "AspNetUsers", type: "bit", nullable: true); migrationBuilder.AddColumn( name: "PendingRegistrationCreatedDate", table: "AspNetUsers", type: "datetime2", nullable: true); migrationBuilder.CreateTable( name: "UserServiceAreas", columns: table => new { UserId = table.Column(type: "nvarchar(450)", maxLength: 450, nullable: false), Area = table.Column(type: "nvarchar(32)", maxLength: 32, nullable: false) }, constraints: table => { table.PrimaryKey("PK_UserServiceAreas", x => new { x.UserId, x.Area }); table.ForeignKey( name: "FK_UserServiceAreas_AspNetUsers_UserId", column: x => x.UserId, principalTable: "AspNetUsers", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateIndex( name: "IX_UserServiceAreas_UserId_Area", table: "UserServiceAreas", columns: new[] { "UserId", "Area" }, unique: true); } /// protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropTable( name: "UserServiceAreas"); migrationBuilder.DropColumn( name: "PendingRegistration", table: "AspNetUsers"); migrationBuilder.DropColumn( name: "PendingRegistrationCreatedDate", table: "AspNetUsers"); } } }