Changeset 0a694bb for FarmatikoData/Migrations/20210205174704_Initial-Migration.cs

Timestamp:

02/07/21 16:25:56 (4 years ago)

Author:

Dimitar Slezenkovski <dslezenkovski@…>

Branches:

master

Children:

e0cdea2

Parents:

ac51326

Message:

Fix create new user bug.

File:

• FarmatikoData/Migrations/20210205174704_Initial-Migration.cs (moved) (moved from FarmatikoData/Migrations/20210124191844_InitialMigration.cs ) (5 diffs)

FarmatikoData/Migrations/20210205174704_Initial-Migration.cs

@@ -15 +15 @@
                     Id = table.Column<int>(nullable: false)
                         .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.SerialColumn),
-                    CreatedOn = table.Column<DateTime>(nullable: false, defaultValueSql: "now()"),
+                    CreatedOn = table.Column<DateTime>(nullable: false, defaultValueSql:"now()"),
                     DeletedOn = table.Column<DateTime>(nullable: true),
                     Name = table.Column<string>(nullable: false),
@@ -125 +125 @@
                     Name = table.Column<string>(nullable: false),
                     Password = table.Column<string>(nullable: false),
-                    UserId = table.Column<int>(nullable: true)
+                    UserID = table.Column<int>(nullable: false)
                 },
                 constraints: table =>
@@ -131 +131 @@
                     table.PrimaryKey("PK_PharmacyHeads", x => x.Id);
                     table.ForeignKey(
-                        name: "FK_PharmacyHeads_Users_UserId",
-                        column: x => x.UserId,
+                        name: "FK_PharmacyHeads_Users_UserID",
+                        column: x => x.UserID,
                         principalTable: "Users",
                         principalColumn: "Id",
-                        onDelete: ReferentialAction.Restrict);
+                        onDelete: ReferentialAction.Cascade);
                 });
 
@@ -172 +172 @@
                     CreatedOn = table.Column<DateTime>(nullable: false, defaultValueSql: "now()"),
                     DeletedOn = table.Column<DateTime>(nullable: true),
-                    PheadId = table.Column<int>(nullable: true),
+                    PheadId = table.Column<int>(nullable: false),
                     HeadId = table.Column<int>(nullable: true),
-                    MedicineId = table.Column<int>(nullable: true)
+                    MedicineId = table.Column<int>(nullable: false)
                 },
                 constraints: table =>
@@ -242 +242 @@
 
             migrationBuilder.CreateIndex(
-                name: "IX_PharmacyHeads_UserId",
+                name: "IX_PharmacyHeads_UserID",
                 table: "PharmacyHeads",
-                column: "UserId");
+                column: "UserID");
 
             migrationBuilder.CreateIndex(