[2aea0fd] | 1 | using System;
|
---|
| 2 | using Microsoft.EntityFrameworkCore.Migrations;
|
---|
| 3 | using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
|
---|
| 4 |
|
---|
| 5 | #nullable disable
|
---|
| 6 |
|
---|
| 7 | namespace PostgreSqlDotnetCore.Migrations
|
---|
| 8 | {
|
---|
| 9 | /// <inheritdoc />
|
---|
| 10 | public partial class Initial : Migration
|
---|
| 11 | {
|
---|
| 12 | /// <inheritdoc />
|
---|
| 13 | protected override void Up(MigrationBuilder migrationBuilder)
|
---|
| 14 | {
|
---|
| 15 | migrationBuilder.EnsureSchema(
|
---|
| 16 | name: "project");
|
---|
| 17 |
|
---|
| 18 | migrationBuilder.CreateTable(
|
---|
| 19 | schema: "project",
|
---|
| 20 | name: "AspNetRoles",
|
---|
| 21 | columns: table => new
|
---|
| 22 | {
|
---|
| 23 | Id = table.Column<string>(type: "text", nullable: false),
|
---|
| 24 | Name = table.Column<string>(type: "character varying(256)", maxLength: 256, nullable: true),
|
---|
| 25 | NormalizedName = table.Column<string>(type: "character varying(256)", maxLength: 256, nullable: true),
|
---|
| 26 | ConcurrencyStamp = table.Column<string>(type: "text", nullable: true)
|
---|
| 27 | },
|
---|
| 28 | constraints: table =>
|
---|
| 29 | {
|
---|
| 30 | table.PrimaryKey("PK_AspNetRoles", x => x.Id);
|
---|
| 31 | });
|
---|
| 32 |
|
---|
| 33 | migrationBuilder.CreateTable(
|
---|
| 34 | schema: "project",
|
---|
| 35 | name: "AspNetUsers",
|
---|
| 36 | columns: table => new
|
---|
| 37 | {
|
---|
| 38 | Id = table.Column<string>(type: "text", nullable: false),
|
---|
| 39 | UserName = table.Column<string>(type: "character varying(256)", maxLength: 256, nullable: true),
|
---|
| 40 | NormalizedUserName = table.Column<string>(type: "character varying(256)", maxLength: 256, nullable: true),
|
---|
| 41 | Email = table.Column<string>(type: "character varying(256)", maxLength: 256, nullable: true),
|
---|
| 42 | NormalizedEmail = table.Column<string>(type: "character varying(256)", maxLength: 256, nullable: true),
|
---|
| 43 | EmailConfirmed = table.Column<bool>(type: "boolean", nullable: false),
|
---|
| 44 | PasswordHash = table.Column<string>(type: "text", nullable: true),
|
---|
| 45 | SecurityStamp = table.Column<string>(type: "text", nullable: true),
|
---|
| 46 | ConcurrencyStamp = table.Column<string>(type: "text", nullable: true),
|
---|
| 47 | PhoneNumber = table.Column<string>(type: "text", nullable: true),
|
---|
| 48 | PhoneNumberConfirmed = table.Column<bool>(type: "boolean", nullable: false),
|
---|
| 49 | TwoFactorEnabled = table.Column<bool>(type: "boolean", nullable: false),
|
---|
| 50 | LockoutEnd = table.Column<DateTimeOffset>(type: "timestamp with time zone", nullable: true),
|
---|
| 51 | LockoutEnabled = table.Column<bool>(type: "boolean", nullable: false),
|
---|
| 52 | AccessFailedCount = table.Column<int>(type: "integer", nullable: false)
|
---|
| 53 | },
|
---|
| 54 | constraints: table =>
|
---|
| 55 | {
|
---|
| 56 | table.PrimaryKey("PK_AspNetUsers", x => x.Id);
|
---|
| 57 | });
|
---|
| 58 |
|
---|
| 59 | migrationBuilder.CreateTable(
|
---|
| 60 | schema: "project",
|
---|
| 61 | name: "AspNetRoleClaims",
|
---|
| 62 | columns: table => new
|
---|
| 63 | {
|
---|
| 64 | Id = table.Column<int>(type: "integer", nullable: false)
|
---|
| 65 | .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
|
---|
| 66 | RoleId = table.Column<string>(type: "text", nullable: false),
|
---|
| 67 | ClaimType = table.Column<string>(type: "text", nullable: true),
|
---|
| 68 | ClaimValue = table.Column<string>(type: "text", nullable: true)
|
---|
| 69 | },
|
---|
| 70 | constraints: table =>
|
---|
| 71 | {
|
---|
| 72 | table.PrimaryKey("PK_AspNetRoleClaims", x => x.Id);
|
---|
| 73 | table.ForeignKey(
|
---|
| 74 | name: "FK_AspNetRoleClaims_AspNetRoles_RoleId",
|
---|
| 75 | column: x => x.RoleId,
|
---|
| 76 | principalTable: "AspNetRoles",
|
---|
| 77 | principalColumn: "Id",
|
---|
| 78 | onDelete: ReferentialAction.Cascade);
|
---|
| 79 | });
|
---|
| 80 |
|
---|
| 81 | migrationBuilder.CreateTable(
|
---|
| 82 | schema: "project",
|
---|
| 83 | name: "AspNetUserClaims",
|
---|
| 84 | columns: table => new
|
---|
| 85 | {
|
---|
| 86 | Id = table.Column<int>(type: "integer", nullable: false)
|
---|
| 87 | .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
|
---|
| 88 | UserId = table.Column<string>(type: "text", nullable: false),
|
---|
| 89 | ClaimType = table.Column<string>(type: "text", nullable: true),
|
---|
| 90 | ClaimValue = table.Column<string>(type: "text", nullable: true)
|
---|
| 91 | },
|
---|
| 92 | constraints: table =>
|
---|
| 93 | {
|
---|
| 94 | table.PrimaryKey("PK_AspNetUserClaims", x => x.Id);
|
---|
| 95 | table.ForeignKey(
|
---|
| 96 | name: "FK_AspNetUserClaims_AspNetUsers_UserId",
|
---|
| 97 | column: x => x.UserId,
|
---|
| 98 | principalTable: "AspNetUsers",
|
---|
| 99 | principalColumn: "Id",
|
---|
| 100 | onDelete: ReferentialAction.Cascade);
|
---|
| 101 | });
|
---|
| 102 |
|
---|
| 103 | migrationBuilder.CreateTable(
|
---|
| 104 | schema: "project",
|
---|
| 105 | name: "AspNetUserLogins",
|
---|
| 106 | columns: table => new
|
---|
| 107 | {
|
---|
| 108 | LoginProvider = table.Column<string>(type: "character varying(128)", maxLength: 128, nullable: false),
|
---|
| 109 | ProviderKey = table.Column<string>(type: "character varying(128)", maxLength: 128, nullable: false),
|
---|
| 110 | ProviderDisplayName = table.Column<string>(type: "text", nullable: true),
|
---|
| 111 | UserId = table.Column<string>(type: "text", 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 | schema: "project",
|
---|
| 126 | name: "AspNetUserRoles",
|
---|
| 127 | columns: table => new
|
---|
| 128 | {
|
---|
| 129 | UserId = table.Column<string>(type: "text", nullable: false),
|
---|
| 130 | RoleId = table.Column<string>(type: "text", nullable: false)
|
---|
| 131 | },
|
---|
| 132 | constraints: table =>
|
---|
| 133 | {
|
---|
| 134 | table.PrimaryKey("PK_AspNetUserRoles", x => new { x.UserId, x.RoleId });
|
---|
| 135 | table.ForeignKey(
|
---|
| 136 | name: "FK_AspNetUserRoles_AspNetRoles_RoleId",
|
---|
| 137 | column: x => x.RoleId,
|
---|
| 138 | principalTable: "AspNetRoles",
|
---|
| 139 | principalColumn: "Id",
|
---|
| 140 | onDelete: ReferentialAction.Cascade);
|
---|
| 141 | table.ForeignKey(
|
---|
| 142 | name: "FK_AspNetUserRoles_AspNetUsers_UserId",
|
---|
| 143 | column: x => x.UserId,
|
---|
| 144 | principalTable: "AspNetUsers",
|
---|
| 145 | principalColumn: "Id",
|
---|
| 146 | onDelete: ReferentialAction.Cascade);
|
---|
| 147 | });
|
---|
| 148 |
|
---|
| 149 | migrationBuilder.CreateTable(
|
---|
| 150 | schema: "project",
|
---|
| 151 | name: "AspNetUserTokens",
|
---|
| 152 | columns: table => new
|
---|
| 153 | {
|
---|
| 154 | UserId = table.Column<string>(type: "text", nullable: false),
|
---|
| 155 | LoginProvider = table.Column<string>(type: "character varying(128)", maxLength: 128, nullable: false),
|
---|
| 156 | Name = table.Column<string>(type: "character varying(128)", maxLength: 128, nullable: false),
|
---|
| 157 | Value = table.Column<string>(type: "text", nullable: true)
|
---|
| 158 | },
|
---|
| 159 | constraints: table =>
|
---|
| 160 | {
|
---|
| 161 | table.PrimaryKey("PK_AspNetUserTokens", x => new { x.UserId, x.LoginProvider, x.Name });
|
---|
| 162 | table.ForeignKey(
|
---|
| 163 | name: "FK_AspNetUserTokens_AspNetUsers_UserId",
|
---|
| 164 | column: x => x.UserId,
|
---|
| 165 | principalTable: "AspNetUsers",
|
---|
| 166 | principalColumn: "Id",
|
---|
| 167 | onDelete: ReferentialAction.Cascade);
|
---|
| 168 | });
|
---|
| 169 |
|
---|
| 170 | migrationBuilder.CreateIndex(
|
---|
| 171 | name: "IX_AspNetRoleClaims_RoleId",
|
---|
| 172 | table: "AspNetRoleClaims",
|
---|
| 173 | column: "RoleId");
|
---|
| 174 |
|
---|
| 175 | migrationBuilder.CreateIndex(
|
---|
| 176 | name: "RoleNameIndex",
|
---|
| 177 | table: "AspNetRoles",
|
---|
| 178 | column: "NormalizedName",
|
---|
| 179 | unique: true);
|
---|
| 180 |
|
---|
| 181 | migrationBuilder.CreateIndex(
|
---|
| 182 | name: "IX_AspNetUserClaims_UserId",
|
---|
| 183 | table: "AspNetUserClaims",
|
---|
| 184 | column: "UserId");
|
---|
| 185 |
|
---|
| 186 | migrationBuilder.CreateIndex(
|
---|
| 187 | name: "IX_AspNetUserLogins_UserId",
|
---|
| 188 | table: "AspNetUserLogins",
|
---|
| 189 | column: "UserId");
|
---|
| 190 |
|
---|
| 191 | migrationBuilder.CreateIndex(
|
---|
| 192 | name: "IX_AspNetUserRoles_RoleId",
|
---|
| 193 | table: "AspNetUserRoles",
|
---|
| 194 | column: "RoleId");
|
---|
| 195 |
|
---|
| 196 | migrationBuilder.CreateIndex(
|
---|
| 197 | name: "EmailIndex",
|
---|
| 198 | table: "AspNetUsers",
|
---|
| 199 | column: "NormalizedEmail");
|
---|
| 200 |
|
---|
| 201 | migrationBuilder.CreateIndex(
|
---|
| 202 | name: "UserNameIndex",
|
---|
| 203 | table: "AspNetUsers",
|
---|
| 204 | column: "NormalizedUserName",
|
---|
| 205 | unique: true);
|
---|
| 206 | }
|
---|
| 207 |
|
---|
| 208 | /// <inheritdoc />
|
---|
| 209 | protected override void Down(MigrationBuilder migrationBuilder)
|
---|
| 210 | {
|
---|
| 211 | migrationBuilder.DropTable(
|
---|
| 212 | name: "AspNetRoleClaims",
|
---|
| 213 | schema: "project");
|
---|
| 214 |
|
---|
| 215 | migrationBuilder.DropTable(
|
---|
| 216 | name: "AspNetUserClaims",
|
---|
| 217 | schema: "project");
|
---|
| 218 |
|
---|
| 219 | migrationBuilder.DropTable(
|
---|
| 220 | name: "AspNetUserLogins",
|
---|
| 221 | schema: "project");
|
---|
| 222 |
|
---|
| 223 | migrationBuilder.DropTable(
|
---|
| 224 | name: "AspNetUserRoles",
|
---|
| 225 | schema: "project");
|
---|
| 226 |
|
---|
| 227 | migrationBuilder.DropTable(
|
---|
| 228 | name: "AspNetUserTokens",
|
---|
| 229 | schema: "project");
|
---|
| 230 |
|
---|
| 231 | migrationBuilder.DropTable(
|
---|
| 232 | name: "AspNetRoles",
|
---|
| 233 | schema: "project");
|
---|
| 234 |
|
---|
| 235 | migrationBuilder.DropTable(
|
---|
| 236 | name: "AspNetUsers",
|
---|
| 237 | schema: "project");
|
---|
| 238 | }
|
---|
| 239 | }
|
---|
| 240 | }
|
---|