1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
| using System;
| using Microsoft.EntityFrameworkCore.Migrations;
|
| #nullable disable
|
| namespace FlexJobApi.Database.Migrations.Migrations
| {
| /// <inheritdoc />
| public partial class UpdateRole : Migration
| {
| /// <inheritdoc />
| 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<int>(
| name: "DataPower",
| table: "RoleResource",
| type: "int",
| nullable: false,
| defaultValue: 0,
| comment: "数据权限",
| oldClrType: typeof(int),
| oldType: "int",
| oldNullable: true,
| oldComment: "数据权限");
|
| migrationBuilder.AddColumn<Guid>(
| 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);
| }
|
| /// <inheritdoc />
| 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<int>(
| name: "DataPower",
| table: "RoleResource",
| type: "int",
| nullable: true,
| comment: "数据权限",
| oldClrType: typeof(int),
| oldType: "int",
| oldComment: "数据权限");
|
| migrationBuilder.AddColumn<Guid>(
| 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);
| }
| }
| }
|
|
