using System; using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace FlexJobApi.Database.Migrations.Migrations { /// public partial class UpdateRole : Migration { /// protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "FK_RoleResource_Menu_MenuId", table: "RoleResource"); migrationBuilder.DropIndex( name: "IX_RoleResource_MenuId", table: "RoleResource"); migrationBuilder.DropColumn( name: "MenuId", table: "RoleResource"); migrationBuilder.AlterColumn( name: "DataPower", table: "RoleResource", type: "int", nullable: false, defaultValue: 0, comment: "数据权限", oldClrType: typeof(int), oldType: "int", oldNullable: true, oldComment: "数据权限"); migrationBuilder.AddColumn( name: "ResourceId", table: "RoleResource", type: "uniqueidentifier", nullable: false, defaultValue: new Guid("00000000-0000-0000-0000-000000000000"), comment: "资源Id"); migrationBuilder.UpdateData( table: "UserAuth", keyColumn: "Id", keyValue: new Guid("11111111-1111-1111-1111-111111111111"), columns: new[] { "Password", "UserName" }, values: new object[] { "iEYggKrMhQ3ASUGLobra1w==:fn/DsMJUbD9FGpvBvR3moMpMPptdxzZlourPVhU479I=", "system" }); migrationBuilder.CreateIndex( name: "IX_RoleResource_ResourceId", table: "RoleResource", column: "ResourceId"); migrationBuilder.AddForeignKey( name: "FK_RoleResource_Resource_ResourceId", table: "RoleResource", column: "ResourceId", principalTable: "Resource", principalColumn: "Id", onDelete: ReferentialAction.Cascade); } /// protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey( name: "FK_RoleResource_Resource_ResourceId", table: "RoleResource"); migrationBuilder.DropIndex( name: "IX_RoleResource_ResourceId", table: "RoleResource"); migrationBuilder.DropColumn( name: "ResourceId", table: "RoleResource"); migrationBuilder.AlterColumn( name: "DataPower", table: "RoleResource", type: "int", nullable: true, comment: "数据权限", oldClrType: typeof(int), oldType: "int", oldComment: "数据权限"); migrationBuilder.AddColumn( name: "MenuId", table: "RoleResource", type: "uniqueidentifier", nullable: false, defaultValue: new Guid("00000000-0000-0000-0000-000000000000"), comment: "菜单Id"); migrationBuilder.UpdateData( table: "UserAuth", keyColumn: "Id", keyValue: new Guid("11111111-1111-1111-1111-111111111111"), columns: new[] { "Password", "UserName" }, values: new object[] { null, "admin" }); migrationBuilder.CreateIndex( name: "IX_RoleResource_MenuId", table: "RoleResource", column: "MenuId"); migrationBuilder.AddForeignKey( name: "FK_RoleResource_Menu_MenuId", table: "RoleResource", column: "MenuId", principalTable: "Menu", principalColumn: "Id", onDelete: ReferentialAction.Cascade); } } }