12 protected override void Up(MigrationBuilder migrationBuilder)
14 ArgumentNullException.ThrowIfNull(migrationBuilder);
16 migrationBuilder.CreateTable(
17 name:
"OidcConnections",
20 Id = table.Column<
long>(type:
"bigint", nullable:
false)
21 .Annotation(
"MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
22 UserId = table.Column<
long>(type:
"bigint", nullable:
false),
23 SchemeKey = table.Column<
string>(type:
"varchar(100)", maxLength: 100, nullable:
false)
24 .Annotation(
"MySql:CharSet",
"utf8mb4"),
25 ExternalUserId = table.Column<
string>(type:
"varchar(100)", maxLength: 100, nullable:
false)
26 .Annotation(
"MySql:CharSet",
"utf8mb4"),
30 table.PrimaryKey(
"PK_OidcConnections", x => x.Id);
32 name:
"FK_OidcConnections_Users_UserId",
33 column: x => x.UserId,
34 principalTable:
"Users",
35 principalColumn:
"Id",
36 onDelete: ReferentialAction.Cascade);
38 .Annotation(
"MySql:CharSet",
"utf8mb4");
40 migrationBuilder.CreateIndex(
41 name:
"IX_OidcConnections_SchemeKey_ExternalUserId",
42 table:
"OidcConnections",
43 columns:
new[] {
"SchemeKey",
"ExternalUserId" },
46 migrationBuilder.CreateIndex(
47 name:
"IX_OidcConnections_UserId",
48 table:
"OidcConnections",