using System; using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace marlin.web.Migrations { /// public partial class CommitAlt : Migration { /// protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropColumn( name: "commit", table: "jobs"); migrationBuilder.DropColumn( name: "ref", table: "jobs"); migrationBuilder.AddColumn( name: "branch_id", table: "jobs", type: "uuid", nullable: false, defaultValue: new Guid("00000000-0000-0000-0000-000000000000")); migrationBuilder.AddColumn( name: "claim_token", table: "jobs", type: "text", nullable: true); migrationBuilder.AddColumn( name: "commit_id", table: "jobs", type: "uuid", nullable: false, defaultValue: new Guid("00000000-0000-0000-0000-000000000000")); migrationBuilder.CreateIndex( name: "ix_jobs_branch_id", table: "jobs", column: "branch_id"); migrationBuilder.CreateIndex( name: "ix_jobs_commit_id", table: "jobs", column: "commit_id"); migrationBuilder.AddForeignKey( name: "fk_jobs_source_branches_branch_id", table: "jobs", column: "branch_id", principalTable: "source_branches", principalColumn: "id", onDelete: ReferentialAction.Cascade); migrationBuilder.AddForeignKey( name: "fk_jobs_source_commits_commit_id", table: "jobs", column: "commit_id", principalTable: "source_commits", principalColumn: "id", onDelete: ReferentialAction.Cascade); } /// protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "fk_jobs_source_branches_branch_id", table: "jobs"); migrationBuilder.DropForeignKey( name: "fk_jobs_source_commits_commit_id", table: "jobs"); migrationBuilder.DropIndex( name: "ix_jobs_branch_id", table: "jobs"); migrationBuilder.DropIndex( name: "ix_jobs_commit_id", table: "jobs"); migrationBuilder.DropColumn( name: "branch_id", table: "jobs"); migrationBuilder.DropColumn( name: "claim_token", table: "jobs"); migrationBuilder.DropColumn( name: "commit_id", table: "jobs"); migrationBuilder.AddColumn( name: "commit", table: "jobs", type: "text", nullable: false, defaultValue: ""); migrationBuilder.AddColumn( name: "ref", table: "jobs", type: "text", nullable: false, defaultValue: ""); } } }