using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace Bit.PostgresMigrations.Migrations; /// public partial class SecurityTasks : Migration { /// protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.CreateTable( name: "SecurityTask", columns: table => new { Id = table.Column(type: "uuid", nullable: false), OrganizationId = table.Column(type: "uuid", nullable: false), CipherId = table.Column(type: "uuid", nullable: true), Type = table.Column(type: "smallint", nullable: false), Status = table.Column(type: "smallint", nullable: false), CreationDate = table.Column(type: "timestamp with time zone", nullable: false), RevisionDate = table.Column(type: "timestamp with time zone", nullable: false) }, constraints: table => { table.PrimaryKey("PK_SecurityTask", x => x.Id); table.ForeignKey( name: "FK_SecurityTask_Cipher_CipherId", column: x => x.CipherId, principalTable: "Cipher", principalColumn: "Id"); table.ForeignKey( name: "FK_SecurityTask_Organization_OrganizationId", column: x => x.OrganizationId, principalTable: "Organization", principalColumn: "Id", onDelete: ReferentialAction.Cascade); }); migrationBuilder.CreateIndex( name: "IX_SecurityTask_CipherId", table: "SecurityTask", column: "CipherId"); migrationBuilder.CreateIndex( name: "IX_SecurityTask_OrganizationId", table: "SecurityTask", column: "OrganizationId"); } /// protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropTable( name: "SecurityTask"); } }