IdentityVSAPI

1
using System;
2
using Microsoft.EntityFrameworkCore.Migrations;
3
using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
4

5
#nullable disable
6

7
namespace IdentityVSAPI.DAL.Migrations
8
{
9
    /// <inheritdoc />
10
    public partial class AddToDbIdentity : Migration
11
    {
12
        /// <inheritdoc />
13
        protected override void Up(MigrationBuilder migrationBuilder)
14
        {
15
            migrationBuilder.CreateTable(
16
                name: "AspNetRoles",
17
                columns: table => new
18
                {
19
                    Id = table.Column<long>(type: "bigint", nullable: false)
20
                        .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
21
                    Name = table.Column<string>(type: "character varying(256)", maxLength: 256, nullable: true),
22
                    NormalizedName = table.Column<string>(type: "character varying(256)", maxLength: 256, nullable: true),
23
                    ConcurrencyStamp = table.Column<string>(type: "text", nullable: true)
24
                },
25
                constraints: table =>
26
                {
27
                    table.PrimaryKey("PK_AspNetRoles", x => x.Id);
28
                });
29

30
            migrationBuilder.CreateTable(
31
                name: "AspNetUsers",
32
                columns: table => new
33
                {
34
                    Id = table.Column<long>(type: "bigint", nullable: false)
35
                        .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
36
                    FirstName = table.Column<string>(type: "text", nullable: false),
37
                    LastName = table.Column<string>(type: "text", nullable: false),
38
                    MiddleName = table.Column<string>(type: "text", nullable: true),
39
                    RefreshToken = table.Column<string>(type: "text", nullable: false),
40
                    RefreshTokenExpiryTime = table.Column<DateTime>(type: "timestamp without time zone", nullable: false),
41
                    BirthDate = table.Column<DateTime>(type: "timestamp without time zone", nullable: false),
42
                    UserName = table.Column<string>(type: "character varying(256)", maxLength: 256, nullable: true),
43
                    NormalizedUserName = table.Column<string>(type: "character varying(256)", maxLength: 256, nullable: true),
44
                    Email = table.Column<string>(type: "character varying(256)", maxLength: 256, nullable: true),
45
                    NormalizedEmail = table.Column<string>(type: "character varying(256)", maxLength: 256, nullable: true),
46
                    EmailConfirmed = table.Column<bool>(type: "boolean", nullable: false),
47
                    PasswordHash = table.Column<string>(type: "text", nullable: true),
48
                    SecurityStamp = table.Column<string>(type: "text", nullable: true),
49
                    ConcurrencyStamp = table.Column<string>(type: "text", nullable: true),
50
                    PhoneNumber = table.Column<string>(type: "text", nullable: true),
51
                    PhoneNumberConfirmed = table.Column<bool>(type: "boolean", nullable: false),
52
                    TwoFactorEnabled = table.Column<bool>(type: "boolean", nullable: false),
53
                    LockoutEnd = table.Column<DateTimeOffset>(type: "timestamp with time zone", nullable: true),
54
                    LockoutEnabled = table.Column<bool>(type: "boolean", nullable: false),
55
                    AccessFailedCount = table.Column<int>(type: "integer", nullable: false)
56
                },
57
                constraints: table =>
58
                {
59
                    table.PrimaryKey("PK_AspNetUsers", x => x.Id);
60
                });
61

62
            migrationBuilder.CreateTable(
63
                name: "AspNetRoleClaims",
64
                columns: table => new
65
                {
66
                    Id = table.Column<int>(type: "integer", nullable: false)
67
                        .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
68
                    RoleId = table.Column<long>(type: "bigint", nullable: false),
69
                    ClaimType = table.Column<string>(type: "text", nullable: true),
70
                    ClaimValue = table.Column<string>(type: "text", nullable: true)
71
                },
72
                constraints: table =>
73
                {
74
                    table.PrimaryKey("PK_AspNetRoleClaims", x => x.Id);
75
                    table.ForeignKey(
76
                        name: "FK_AspNetRoleClaims_AspNetRoles_RoleId",
77
                        column: x => x.RoleId,
78
                        principalTable: "AspNetRoles",
79
                        principalColumn: "Id",
80
                        onDelete: ReferentialAction.Cascade);
81
                });
82

83
            migrationBuilder.CreateTable(
84
                name: "AspNetUserClaims",
85
                columns: table => new
86
                {
87
                    Id = table.Column<int>(type: "integer", nullable: false)
88
                        .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
89
                    UserId = table.Column<long>(type: "bigint", nullable: false),
90
                    ClaimType = table.Column<string>(type: "text", nullable: true),
91
                    ClaimValue = table.Column<string>(type: "text", nullable: true)
92
                },
93
                constraints: table =>
94
                {
95
                    table.PrimaryKey("PK_AspNetUserClaims", x => x.Id);
96
                    table.ForeignKey(
97
                        name: "FK_AspNetUserClaims_AspNetUsers_UserId",
98
                        column: x => x.UserId,
99
                        principalTable: "AspNetUsers",
100
                        principalColumn: "Id",
101
                        onDelete: ReferentialAction.Cascade);
102
                });
103

104
            migrationBuilder.CreateTable(
105
                name: "AspNetUserLogins",
106
                columns: table => new
107
                {
108
                    LoginProvider = table.Column<string>(type: "text", nullable: false),
109
                    ProviderKey = table.Column<string>(type: "text", nullable: false),
110
                    ProviderDisplayName = table.Column<string>(type: "text", nullable: true),
111
                    UserId = table.Column<long>(type: "bigint", nullable: false)
112
                },
113
                constraints: table =>
114
                {
115
                    table.PrimaryKey("PK_AspNetUserLogins", x => new { x.LoginProvider, x.ProviderKey });
116
                    table.ForeignKey(
117
                        name: "FK_AspNetUserLogins_AspNetUsers_UserId",
118
                        column: x => x.UserId,
119
                        principalTable: "AspNetUsers",
120
                        principalColumn: "Id",
121
                        onDelete: ReferentialAction.Cascade);
122
                });
123

124
            migrationBuilder.CreateTable(
125
                name: "AspNetUserRoles",
126
                columns: table => new
127
                {
128
                    UserId = table.Column<long>(type: "bigint", nullable: false),
129
                    RoleId = table.Column<long>(type: "bigint", nullable: false)
130
                },
131
                constraints: table =>
132
                {
133
                    table.PrimaryKey("PK_AspNetUserRoles", x => new { x.UserId, x.RoleId });
134
                    table.ForeignKey(
135
                        name: "FK_AspNetUserRoles_AspNetRoles_RoleId",
136
                        column: x => x.RoleId,
137
                        principalTable: "AspNetRoles",
138
                        principalColumn: "Id",
139
                        onDelete: ReferentialAction.Cascade);
140
                    table.ForeignKey(
141
                        name: "FK_AspNetUserRoles_AspNetUsers_UserId",
142
                        column: x => x.UserId,
143
                        principalTable: "AspNetUsers",
144
                        principalColumn: "Id",
145
                        onDelete: ReferentialAction.Cascade);
146
                });
147

148
            migrationBuilder.CreateTable(
149
                name: "AspNetUserTokens",
150
                columns: table => new
151
                {
152
                    UserId = table.Column<long>(type: "bigint", nullable: false),
153
                    LoginProvider = table.Column<string>(type: "text", nullable: false),
154
                    Name = table.Column<string>(type: "text", nullable: false),
155
                    Value = table.Column<string>(type: "text", nullable: true)
156
                },
157
                constraints: table =>
158
                {
159
                    table.PrimaryKey("PK_AspNetUserTokens", x => new { x.UserId, x.LoginProvider, x.Name });
160
                    table.ForeignKey(
161
                        name: "FK_AspNetUserTokens_AspNetUsers_UserId",
162
                        column: x => x.UserId,
163
                        principalTable: "AspNetUsers",
164
                        principalColumn: "Id",
165
                        onDelete: ReferentialAction.Cascade);
166
                });
167

168
            migrationBuilder.CreateIndex(
169
                name: "IX_AspNetRoleClaims_RoleId",
170
                table: "AspNetRoleClaims",
171
                column: "RoleId");
172

173
            migrationBuilder.CreateIndex(
174
                name: "RoleNameIndex",
175
                table: "AspNetRoles",
176
                column: "NormalizedName",
177
                unique: true);
178

179
            migrationBuilder.CreateIndex(
180
                name: "IX_AspNetUserClaims_UserId",
181
                table: "AspNetUserClaims",
182
                column: "UserId");
183

184
            migrationBuilder.CreateIndex(
185
                name: "IX_AspNetUserLogins_UserId",
186
                table: "AspNetUserLogins",
187
                column: "UserId");
188

189
            migrationBuilder.CreateIndex(
190
                name: "IX_AspNetUserRoles_RoleId",
191
                table: "AspNetUserRoles",
192
                column: "RoleId");
193

194
            migrationBuilder.CreateIndex(
195
                name: "EmailIndex",
196
                table: "AspNetUsers",
197
                column: "NormalizedEmail");
198

199
            migrationBuilder.CreateIndex(
200
                name: "UserNameIndex",
201
                table: "AspNetUsers",
202
                column: "NormalizedUserName",
203
                unique: true);
204
        }
205

206
        /// <inheritdoc />
207
        protected override void Down(MigrationBuilder migrationBuilder)
208
        {
209
            migrationBuilder.DropTable(
210
                name: "AspNetRoleClaims");
211

212
            migrationBuilder.DropTable(
213
                name: "AspNetUserClaims");
214

215
            migrationBuilder.DropTable(
216
                name: "AspNetUserLogins");
217

218
            migrationBuilder.DropTable(
219
                name: "AspNetUserRoles");
220

221
            migrationBuilder.DropTable(
222
                name: "AspNetUserTokens");
223

224
            migrationBuilder.DropTable(
225
                name: "AspNetRoles");
226

227
            migrationBuilder.DropTable(
228
                name: "AspNetUsers");
229
        }
230
    }
231
}
232