Changeset aee2b88 for iknow-api/Migrations/20251216191800_InitialCreate.cs

Timestamp:

12/16/25 23:05:19 (9 months ago)

Author:

Stefan-Saveski <stefansaveski19@…>

Branches:

master

Children:

bb02e3a

Parents:

61fd94e

Message:

Upgraded database, added get subjects and get passed subjects.

File:

• iknow-api/Migrations/20251216191800_InitialCreate.cs (moved) (moved from iknow-api/Migrations/20251211135004_inital.cs ) (8 diffs)

iknow-api/Migrations/20251216191800_InitialCreate.cs

@@ -10 +10 @@
 {
     /// <inheritdoc />
-    public partial class inital : Migration
+    public partial class InitialCreate : Migration
     {
         /// <inheritdoc />
@@ -19 +19 @@
                 columns: table => new
                 {
-                    id = table.Column<int>(type: "integer", nullable: false)
-                        .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
-                    year = table.Column<int>(type: "integer", nullable: false),
+                    Id = table.Column<int>(type: "integer", nullable: false)
+                        .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
+                    Year = table.Column<int>(type: "integer", nullable: false),
                     Type = table.Column<int>(type: "integer", nullable: false)
                 },
                 constraints: table =>
                 {
-                    table.PrimaryKey("PK_ActiveSemesters", x => x.id);
+                    table.PrimaryKey("PK_ActiveSemesters", x => x.Id);
                 });
 
@@ -181 +181 @@
                     MajorId = table.Column<int>(type: "integer", nullable: false),
                     StudentComment = table.Column<string>(type: "text", nullable: true),
-                    Node = table.Column<string>(type: "text", nullable: true),
+                    Note = table.Column<string>(type: "text", nullable: true),
                     CratedAt = table.Column<DateTime>(type: "timestamp with time zone", nullable: false),
                     LastChange = table.Column<DateTime>(type: "timestamp with time zone", nullable: false),
-                    Veryfied = table.Column<DateTime>(type: "timestamp with time zone", nullable: false)
+                    Verified = table.Column<DateTime>(type: "timestamp with time zone", nullable: false),
+                    SemesterId = table.Column<int>(type: "integer", nullable: false)
                 },
                 constraints: table =>
@@ -193 +194 @@
                         column: x => x.Id,
                         principalTable: "ActiveSemesters",
-                        principalColumn: "id",
+                        principalColumn: "Id",
                         onDelete: ReferentialAction.Restrict);
                     table.ForeignKey(
@@ -215 +216 @@
                     Id = table.Column<int>(type: "integer", nullable: false)
                         .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
-                    enrollmentYear = table.Column<int>(type: "integer", nullable: false),
-                    quota = table.Column<int>(type: "integer", nullable: false),
+                    EnrollmentYear = table.Column<int>(type: "integer", nullable: false),
+                    Quota = table.Column<int>(type: "integer", nullable: false),
                     MajorId = table.Column<int>(type: "integer", nullable: false),
                     UserId = table.Column<int>(type: "integer", nullable: false),
@@ -256 +257 @@
                         name: "FK_HighSchool_User_UserId",
                         column: x => x.UserId,
+                        principalTable: "User",
+                        principalColumn: "Id",
+                        onDelete: ReferentialAction.Cascade);
+                });
+
+            migrationBuilder.CreateTable(
+                name: "ProfessorSubjects",
+                columns: table => new
+                {
+                    ProfessorId = table.Column<int>(type: "integer", nullable: false),
+                    SemesterId = table.Column<int>(type: "integer", nullable: false),
+                    SubjectId = table.Column<int>(type: "integer", nullable: false)
+                },
+                constraints: table =>
+                {
+                    table.PrimaryKey("PK_ProfessorSubjects", x => new { x.ProfessorId, x.SemesterId, x.SubjectId });
+                    table.ForeignKey(
+                        name: "FK_ProfessorSubjects_ActiveSemesters_SemesterId",
+                        column: x => x.SemesterId,
+                        principalTable: "ActiveSemesters",
+                        principalColumn: "Id",
+                        onDelete: ReferentialAction.Cascade);
+                    table.ForeignKey(
+                        name: "FK_ProfessorSubjects_Subjects_SubjectId",
+                        column: x => x.SubjectId,
+                        principalTable: "Subjects",
+                        principalColumn: "Id",
+                        onDelete: ReferentialAction.Cascade);
+                    table.ForeignKey(
+                        name: "FK_ProfessorSubjects_User_ProfessorId",
+                        column: x => x.ProfessorId,
                         principalTable: "User",
                         principalColumn: "Id",
@@ -466 +498 @@
 
             migrationBuilder.CreateIndex(
+                name: "IX_ProfessorSubjects_SemesterId",
+                table: "ProfessorSubjects",
+                column: "SemesterId");
+
+            migrationBuilder.CreateIndex(
+                name: "IX_ProfessorSubjects_SubjectId",
+                table: "ProfessorSubjects",
+                column: "SubjectId");
+
+            migrationBuilder.CreateIndex(
                 name: "IX_RefreshToken_UserId",
                 table: "RefreshToken",
@@ -521 +563 @@
 
             migrationBuilder.DropTable(
+                name: "ProfessorSubjects");
+
+            migrationBuilder.DropTable(
                 name: "RefreshToken");