Index: ChapterX.Infrastructure/Migrations/20260319165332_InitialCreate.Designer.cs
===================================================================
--- ChapterX.Infrastructure/Migrations/20260319165332_InitialCreate.Designer.cs (revision b62cefc14094ca5ac7154f7d48797a1e6c444935)
+++ (revision )
@@ -1,852 +1,0 @@
-//
-using System;
-using ChapterX.Infrastructure.Data.DataContext;
-using Microsoft.EntityFrameworkCore;
-using Microsoft.EntityFrameworkCore.Infrastructure;
-using Microsoft.EntityFrameworkCore.Migrations;
-using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
-using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
-
-#nullable disable
-
-namespace ChapterX.Infrastructure.Migrations
-{
- [DbContext(typeof(ApplicationDbContext))]
- [Migration("20260319165332_InitialCreate")]
- partial class InitialCreate
- {
- ///
- protected override void BuildTargetModel(ModelBuilder modelBuilder)
- {
-#pragma warning disable 612, 618
- modelBuilder
- .HasAnnotation("ProductVersion", "9.0.1")
- .HasAnnotation("Relational:MaxIdentifierLength", 63);
-
- NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder);
-
- modelBuilder.Entity("ChapterX.Domain.Entities.AISuggestion", b =>
- {
- b.Property("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("integer");
-
- NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id"));
-
- b.Property("Accepted")
- .HasColumnType("boolean");
-
- b.Property("AppliedAt")
- .HasColumnType("timestamp with time zone");
-
- b.Property("CreatedAt")
- .HasColumnType("timestamp with time zone");
-
- b.Property("OriginalText")
- .IsRequired()
- .HasColumnType("text");
-
- b.Property("StoryId")
- .HasColumnType("integer");
-
- b.Property("SuggestedText")
- .IsRequired()
- .HasColumnType("text");
-
- b.PrimitiveCollection("SuggestionTypes")
- .IsRequired()
- .HasColumnType("integer[]");
-
- b.HasKey("Id");
-
- b.HasIndex("StoryId");
-
- b.ToTable("AISuggestions");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.Admin", b =>
- {
- b.Property("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("integer");
-
- NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id"));
-
- b.Property("UserId")
- .HasColumnType("integer");
-
- b.HasKey("Id");
-
- b.HasIndex("UserId")
- .IsUnique();
-
- b.ToTable("Admins");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.Chapter", b =>
- {
- b.Property("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("integer");
-
- NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id"));
-
- b.Property("Content")
- .IsRequired()
- .HasColumnType("text");
-
- b.Property("CreatedAt")
- .HasColumnType("timestamp with time zone");
-
- b.Property("Name")
- .IsRequired()
- .HasColumnType("text");
-
- b.Property("Number")
- .HasColumnType("integer");
-
- b.Property("PublishedAt")
- .HasColumnType("timestamp with time zone");
-
- b.Property("Rating")
- .HasColumnType("numeric");
-
- b.Property("StoryId")
- .HasColumnType("integer");
-
- b.Property("Title")
- .IsRequired()
- .HasColumnType("text");
-
- b.Property("UpdatedAt")
- .HasColumnType("timestamp with time zone");
-
- b.Property("ViewCount")
- .HasColumnType("integer");
-
- b.Property("WordCount")
- .HasColumnType("integer");
-
- b.HasKey("Id");
-
- b.HasIndex("StoryId");
-
- b.ToTable("Chapters");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.Collaboration", b =>
- {
- b.Property("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("integer");
-
- NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id"));
-
- b.Property("JoinedAt")
- .HasColumnType("timestamp with time zone");
-
- b.Property("Role")
- .IsRequired()
- .HasColumnType("text");
-
- b.Property("StoryId")
- .HasColumnType("integer");
-
- b.Property("UserId")
- .HasColumnType("integer");
-
- b.HasKey("Id");
-
- b.HasIndex("StoryId");
-
- b.HasIndex("UserId");
-
- b.ToTable("Collaborations");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.Comment", b =>
- {
- b.Property("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("integer");
-
- NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id"));
-
- b.Property("Content")
- .IsRequired()
- .HasColumnType("text");
-
- b.Property("CreatedAt")
- .HasColumnType("timestamp with time zone");
-
- b.Property("StoryId")
- .HasColumnType("integer");
-
- b.Property("UpdatedAt")
- .HasColumnType("timestamp with time zone");
-
- b.Property("UserId")
- .HasColumnType("integer");
-
- b.HasKey("Id");
-
- b.HasIndex("StoryId");
-
- b.HasIndex("UserId");
-
- b.ToTable("Comments");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.Genre", b =>
- {
- b.Property("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("integer");
-
- NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id"));
-
- b.Property("Name")
- .IsRequired()
- .HasColumnType("text");
-
- b.HasKey("Id");
-
- b.ToTable("Genres");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.HasGenre", b =>
- {
- b.Property("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("integer");
-
- NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id"));
-
- b.Property("GenreId")
- .HasColumnType("integer");
-
- b.Property("StoryId")
- .HasColumnType("integer");
-
- b.HasKey("Id");
-
- b.HasIndex("GenreId");
-
- b.HasIndex("StoryId");
-
- b.ToTable("HasGenres");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.Likes", b =>
- {
- b.Property("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("integer");
-
- NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id"));
-
- b.Property("ChapterId")
- .HasColumnType("integer");
-
- b.Property("CreatedAt")
- .HasColumnType("timestamp with time zone");
-
- b.Property("StoryId")
- .HasColumnType("integer");
-
- b.Property("UserId")
- .HasColumnType("integer");
-
- b.HasKey("Id");
-
- b.HasIndex("ChapterId");
-
- b.HasIndex("StoryId");
-
- b.HasIndex("UserId");
-
- b.ToTable("Likes");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.NeedApproval", b =>
- {
- b.Property("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("integer");
-
- NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id"));
-
- b.Property("AISuggestionId")
- .HasColumnType("integer");
-
- b.Property("AdminId")
- .HasColumnType("integer");
-
- b.Property("Approved")
- .HasColumnType("boolean");
-
- b.Property("ChapterId")
- .HasColumnType("integer");
-
- b.Property("RequestedAt")
- .HasColumnType("timestamp with time zone");
-
- b.Property("StoryId")
- .HasColumnType("integer");
-
- b.HasKey("Id");
-
- b.HasIndex("AISuggestionId");
-
- b.HasIndex("AdminId");
-
- b.HasIndex("ChapterId");
-
- b.HasIndex("StoryId");
-
- b.ToTable("NeedApprovals");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.Notification", b =>
- {
- b.Property("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("integer");
-
- NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id"));
-
- b.Property("Content")
- .IsRequired()
- .HasColumnType("text");
-
- b.PrimitiveCollection("ContentTypes")
- .IsRequired()
- .HasColumnType("integer[]");
-
- b.Property("CreatedAt")
- .HasColumnType("timestamp with time zone");
-
- b.Property("IsRead")
- .HasColumnType("boolean");
-
- b.HasKey("Id");
-
- b.ToTable("Notifications");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.Notify", b =>
- {
- b.Property("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("integer");
-
- NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id"));
-
- b.Property("IsRead")
- .HasColumnType("boolean");
-
- b.Property("NotificationId")
- .HasColumnType("integer");
-
- b.Property("StoryId")
- .HasColumnType("integer");
-
- b.Property("UserId")
- .HasColumnType("integer");
-
- b.HasKey("Id");
-
- b.HasIndex("NotificationId");
-
- b.HasIndex("StoryId");
-
- b.HasIndex("UserId");
-
- b.ToTable("Notifies");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.ReadingList", b =>
- {
- b.Property("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("integer");
-
- NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id"));
-
- b.Property("Content")
- .HasColumnType("text");
-
- b.Property("CreatedAt")
- .HasColumnType("timestamp with time zone");
-
- b.Property("IsPublic")
- .HasColumnType("boolean");
-
- b.Property("Name")
- .IsRequired()
- .HasColumnType("text");
-
- b.Property("UpdatedAt")
- .HasColumnType("timestamp with time zone");
-
- b.Property("UserId")
- .HasColumnType("integer");
-
- b.HasKey("Id");
-
- b.HasIndex("UserId");
-
- b.ToTable("ReadingLists");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.ReadingListItems", b =>
- {
- b.Property("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("integer");
-
- NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id"));
-
- b.Property("AddedAt")
- .HasColumnType("timestamp with time zone");
-
- b.Property("ReadingListId")
- .HasColumnType("integer");
-
- b.Property("StoryId")
- .HasColumnType("integer");
-
- b.HasKey("Id");
-
- b.HasIndex("ReadingListId");
-
- b.HasIndex("StoryId");
-
- b.ToTable("ReadingListItems");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.RegularUser", b =>
- {
- b.Property("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("integer");
-
- NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id"));
-
- b.Property("UserId")
- .HasColumnType("integer");
-
- b.HasKey("Id");
-
- b.HasIndex("UserId")
- .IsUnique();
-
- b.ToTable("RegularUsers");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.Story", b =>
- {
- b.Property("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("integer");
-
- NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id"));
-
- b.Property("Content")
- .IsRequired()
- .HasColumnType("text");
-
- b.Property("CreatedAt")
- .HasColumnType("timestamp with time zone");
-
- b.Property("Image")
- .HasColumnType("text");
-
- b.Property("MatureContent")
- .HasColumnType("boolean");
-
- b.Property("ShortDescription")
- .IsRequired()
- .HasColumnType("text");
-
- b.PrimitiveCollection("Statuses")
- .IsRequired()
- .HasColumnType("integer[]");
-
- b.Property("UpdatedAt")
- .HasColumnType("timestamp with time zone");
-
- b.Property("UserId")
- .HasColumnType("integer");
-
- b.Property("WriterId")
- .HasColumnType("integer");
-
- b.HasKey("Id");
-
- b.HasIndex("WriterId");
-
- b.ToTable("Stories");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.User", b =>
- {
- b.Property("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("integer");
-
- NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id"));
-
- b.Property("CreatedAt")
- .HasColumnType("timestamp with time zone");
-
- b.Property("Email")
- .IsRequired()
- .HasColumnType("text");
-
- b.Property("Name")
- .IsRequired()
- .HasColumnType("text");
-
- b.Property("Password")
- .IsRequired()
- .HasColumnType("text");
-
- b.Property("Surname")
- .IsRequired()
- .HasColumnType("text");
-
- b.Property("UpdatedAt")
- .HasColumnType("timestamp with time zone");
-
- b.Property("Username")
- .IsRequired()
- .HasColumnType("text");
-
- b.HasKey("Id");
-
- b.ToTable("Users");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.Writer", b =>
- {
- b.Property("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("integer");
-
- NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id"));
-
- b.Property("Bio")
- .IsRequired()
- .HasColumnType("text");
-
- b.Property("UserId")
- .HasColumnType("integer");
-
- b.HasKey("Id");
-
- b.HasIndex("UserId")
- .IsUnique();
-
- b.ToTable("Writers");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.AISuggestion", b =>
- {
- b.HasOne("ChapterX.Domain.Entities.Story", "Story")
- .WithMany("AISuggestions")
- .HasForeignKey("StoryId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
-
- b.Navigation("Story");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.Admin", b =>
- {
- b.HasOne("ChapterX.Domain.Entities.User", "User")
- .WithOne("Admin")
- .HasForeignKey("ChapterX.Domain.Entities.Admin", "UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.Chapter", b =>
- {
- b.HasOne("ChapterX.Domain.Entities.Story", "Story")
- .WithMany("Chapters")
- .HasForeignKey("StoryId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
-
- b.Navigation("Story");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.Collaboration", b =>
- {
- b.HasOne("ChapterX.Domain.Entities.Story", "Story")
- .WithMany("Collaborations")
- .HasForeignKey("StoryId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
-
- b.HasOne("ChapterX.Domain.Entities.User", "User")
- .WithMany("Collaborations")
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
-
- b.Navigation("Story");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.Comment", b =>
- {
- b.HasOne("ChapterX.Domain.Entities.Story", "Story")
- .WithMany("Comments")
- .HasForeignKey("StoryId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
-
- b.HasOne("ChapterX.Domain.Entities.User", "User")
- .WithMany("Comments")
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
-
- b.Navigation("Story");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.HasGenre", b =>
- {
- b.HasOne("ChapterX.Domain.Entities.Genre", "Genre")
- .WithMany("HasGenres")
- .HasForeignKey("GenreId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
-
- b.HasOne("ChapterX.Domain.Entities.Story", "Story")
- .WithMany("HasGenres")
- .HasForeignKey("StoryId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
-
- b.Navigation("Genre");
-
- b.Navigation("Story");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.Likes", b =>
- {
- b.HasOne("ChapterX.Domain.Entities.Chapter", "Chapter")
- .WithMany()
- .HasForeignKey("ChapterId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
-
- b.HasOne("ChapterX.Domain.Entities.Story", null)
- .WithMany("Likes")
- .HasForeignKey("StoryId");
-
- b.HasOne("ChapterX.Domain.Entities.User", "User")
- .WithMany("Likes")
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
-
- b.Navigation("Chapter");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.NeedApproval", b =>
- {
- b.HasOne("ChapterX.Domain.Entities.AISuggestion", null)
- .WithMany("NeedApprovals")
- .HasForeignKey("AISuggestionId");
-
- b.HasOne("ChapterX.Domain.Entities.Admin", "Admin")
- .WithMany()
- .HasForeignKey("AdminId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
-
- b.HasOne("ChapterX.Domain.Entities.Chapter", null)
- .WithMany("NeedApprovals")
- .HasForeignKey("ChapterId");
-
- b.HasOne("ChapterX.Domain.Entities.Story", "Story")
- .WithMany("NeedApprovals")
- .HasForeignKey("StoryId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
-
- b.Navigation("Admin");
-
- b.Navigation("Story");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.Notify", b =>
- {
- b.HasOne("ChapterX.Domain.Entities.Notification", "Notification")
- .WithMany("Notifies")
- .HasForeignKey("NotificationId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
-
- b.HasOne("ChapterX.Domain.Entities.Story", null)
- .WithMany("Notifies")
- .HasForeignKey("StoryId");
-
- b.HasOne("ChapterX.Domain.Entities.User", "User")
- .WithMany("Notifies")
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
-
- b.Navigation("Notification");
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.ReadingList", b =>
- {
- b.HasOne("ChapterX.Domain.Entities.User", "User")
- .WithMany("ReadingLists")
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.ReadingListItems", b =>
- {
- b.HasOne("ChapterX.Domain.Entities.ReadingList", "ReadingList")
- .WithMany("ReadingListItems")
- .HasForeignKey("ReadingListId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
-
- b.HasOne("ChapterX.Domain.Entities.Story", "Story")
- .WithMany("ReadingListItems")
- .HasForeignKey("StoryId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
-
- b.Navigation("ReadingList");
-
- b.Navigation("Story");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.RegularUser", b =>
- {
- b.HasOne("ChapterX.Domain.Entities.User", "User")
- .WithOne("RegularUser")
- .HasForeignKey("ChapterX.Domain.Entities.RegularUser", "UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.Story", b =>
- {
- b.HasOne("ChapterX.Domain.Entities.Writer", "Writer")
- .WithMany("Stories")
- .HasForeignKey("WriterId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
-
- b.Navigation("Writer");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.Writer", b =>
- {
- b.HasOne("ChapterX.Domain.Entities.User", "User")
- .WithOne("Writer")
- .HasForeignKey("ChapterX.Domain.Entities.Writer", "UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.AISuggestion", b =>
- {
- b.Navigation("NeedApprovals");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.Chapter", b =>
- {
- b.Navigation("NeedApprovals");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.Genre", b =>
- {
- b.Navigation("HasGenres");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.Notification", b =>
- {
- b.Navigation("Notifies");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.ReadingList", b =>
- {
- b.Navigation("ReadingListItems");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.Story", b =>
- {
- b.Navigation("AISuggestions");
-
- b.Navigation("Chapters");
-
- b.Navigation("Collaborations");
-
- b.Navigation("Comments");
-
- b.Navigation("HasGenres");
-
- b.Navigation("Likes");
-
- b.Navigation("NeedApprovals");
-
- b.Navigation("Notifies");
-
- b.Navigation("ReadingListItems");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.User", b =>
- {
- b.Navigation("Admin");
-
- b.Navigation("Collaborations");
-
- b.Navigation("Comments");
-
- b.Navigation("Likes");
-
- b.Navigation("Notifies");
-
- b.Navigation("ReadingLists");
-
- b.Navigation("RegularUser");
-
- b.Navigation("Writer");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.Writer", b =>
- {
- b.Navigation("Stories");
- });
-#pragma warning restore 612, 618
- }
- }
-}
Index: ChapterX.Infrastructure/Migrations/20260319165332_InitialCreate.cs
===================================================================
--- ChapterX.Infrastructure/Migrations/20260319165332_InitialCreate.cs (revision b62cefc14094ca5ac7154f7d48797a1e6c444935)
+++ (revision )
@@ -1,626 +1,0 @@
-using System;
-using Microsoft.EntityFrameworkCore.Migrations;
-using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
-
-#nullable disable
-
-namespace ChapterX.Infrastructure.Migrations
-{
- ///
- public partial class InitialCreate : Migration
- {
- ///
- protected override void Up(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.CreateTable(
- name: "Genres",
- columns: table => new
- {
- Id = table.Column(type: "integer", nullable: false)
- .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
- Name = table.Column(type: "text", nullable: false)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_Genres", x => x.Id);
- });
-
- migrationBuilder.CreateTable(
- name: "Notifications",
- columns: table => new
- {
- Id = table.Column(type: "integer", nullable: false)
- .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
- Content = table.Column(type: "text", nullable: false),
- IsRead = table.Column(type: "boolean", nullable: false),
- CreatedAt = table.Column(type: "timestamp with time zone", nullable: false),
- ContentTypes = table.Column(type: "integer[]", nullable: false)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_Notifications", x => x.Id);
- });
-
- migrationBuilder.CreateTable(
- name: "Users",
- columns: table => new
- {
- Id = table.Column(type: "integer", nullable: false)
- .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
- Username = table.Column(type: "text", nullable: false),
- Email = table.Column(type: "text", nullable: false),
- Name = table.Column(type: "text", nullable: false),
- Surname = table.Column(type: "text", nullable: false),
- Password = table.Column(type: "text", nullable: false),
- CreatedAt = table.Column(type: "timestamp with time zone", nullable: false),
- UpdatedAt = table.Column(type: "timestamp with time zone", nullable: false)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_Users", x => x.Id);
- });
-
- migrationBuilder.CreateTable(
- name: "Admins",
- columns: table => new
- {
- Id = table.Column(type: "integer", nullable: false)
- .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
- UserId = table.Column(type: "integer", nullable: false)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_Admins", x => x.Id);
- table.ForeignKey(
- name: "FK_Admins_Users_UserId",
- column: x => x.UserId,
- principalTable: "Users",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- });
-
- migrationBuilder.CreateTable(
- name: "ReadingLists",
- columns: table => new
- {
- Id = table.Column(type: "integer", nullable: false)
- .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
- Name = table.Column(type: "text", nullable: false),
- Content = table.Column(type: "text", nullable: true),
- IsPublic = table.Column(type: "boolean", nullable: false),
- CreatedAt = table.Column(type: "timestamp with time zone", nullable: false),
- UpdatedAt = table.Column(type: "timestamp with time zone", nullable: false),
- UserId = table.Column(type: "integer", nullable: false)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_ReadingLists", x => x.Id);
- table.ForeignKey(
- name: "FK_ReadingLists_Users_UserId",
- column: x => x.UserId,
- principalTable: "Users",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- });
-
- migrationBuilder.CreateTable(
- name: "RegularUsers",
- columns: table => new
- {
- Id = table.Column(type: "integer", nullable: false)
- .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
- UserId = table.Column(type: "integer", nullable: false)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_RegularUsers", x => x.Id);
- table.ForeignKey(
- name: "FK_RegularUsers_Users_UserId",
- column: x => x.UserId,
- principalTable: "Users",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- });
-
- migrationBuilder.CreateTable(
- name: "Writers",
- columns: table => new
- {
- Id = table.Column(type: "integer", nullable: false)
- .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
- UserId = table.Column(type: "integer", nullable: false),
- Bio = table.Column(type: "text", nullable: false)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_Writers", x => x.Id);
- table.ForeignKey(
- name: "FK_Writers_Users_UserId",
- column: x => x.UserId,
- principalTable: "Users",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- });
-
- migrationBuilder.CreateTable(
- name: "Stories",
- columns: table => new
- {
- Id = table.Column(type: "integer", nullable: false)
- .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
- MatureContent = table.Column(type: "boolean", nullable: false),
- ShortDescription = table.Column(type: "text", nullable: false),
- Image = table.Column(type: "text", nullable: true),
- Content = table.Column(type: "text", nullable: false),
- CreatedAt = table.Column(type: "timestamp with time zone", nullable: false),
- UpdatedAt = table.Column(type: "timestamp with time zone", nullable: false),
- UserId = table.Column(type: "integer", nullable: false),
- WriterId = table.Column(type: "integer", nullable: false),
- Statuses = table.Column(type: "integer[]", nullable: false)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_Stories", x => x.Id);
- table.ForeignKey(
- name: "FK_Stories_Writers_WriterId",
- column: x => x.WriterId,
- principalTable: "Writers",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- });
-
- migrationBuilder.CreateTable(
- name: "AISuggestions",
- columns: table => new
- {
- Id = table.Column(type: "integer", nullable: false)
- .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
- OriginalText = table.Column(type: "text", nullable: false),
- SuggestedText = table.Column(type: "text", nullable: false),
- Accepted = table.Column(type: "boolean", nullable: false),
- CreatedAt = table.Column(type: "timestamp with time zone", nullable: false),
- AppliedAt = table.Column(type: "timestamp with time zone", nullable: true),
- StoryId = table.Column(type: "integer", nullable: false),
- SuggestionTypes = table.Column(type: "integer[]", nullable: false)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_AISuggestions", x => x.Id);
- table.ForeignKey(
- name: "FK_AISuggestions_Stories_StoryId",
- column: x => x.StoryId,
- principalTable: "Stories",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- });
-
- migrationBuilder.CreateTable(
- name: "Chapters",
- columns: table => new
- {
- Id = table.Column(type: "integer", nullable: false)
- .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
- Number = table.Column(type: "integer", nullable: false),
- Name = table.Column(type: "text", nullable: false),
- Title = table.Column(type: "text", nullable: false),
- Content = table.Column(type: "text", nullable: false),
- WordCount = table.Column(type: "integer", nullable: true),
- Rating = table.Column(type: "numeric", nullable: true),
- PublishedAt = table.Column(type: "timestamp with time zone", nullable: false),
- ViewCount = table.Column(type: "integer", nullable: false),
- CreatedAt = table.Column(type: "timestamp with time zone", nullable: false),
- UpdatedAt = table.Column(type: "timestamp with time zone", nullable: false),
- StoryId = table.Column(type: "integer", nullable: false)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_Chapters", x => x.Id);
- table.ForeignKey(
- name: "FK_Chapters_Stories_StoryId",
- column: x => x.StoryId,
- principalTable: "Stories",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- });
-
- migrationBuilder.CreateTable(
- name: "Collaborations",
- columns: table => new
- {
- Id = table.Column(type: "integer", nullable: false)
- .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
- UserId = table.Column(type: "integer", nullable: false),
- StoryId = table.Column(type: "integer", nullable: false),
- Role = table.Column(type: "text", nullable: false),
- JoinedAt = table.Column(type: "timestamp with time zone", nullable: false)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_Collaborations", x => x.Id);
- table.ForeignKey(
- name: "FK_Collaborations_Stories_StoryId",
- column: x => x.StoryId,
- principalTable: "Stories",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- table.ForeignKey(
- name: "FK_Collaborations_Users_UserId",
- column: x => x.UserId,
- principalTable: "Users",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- });
-
- migrationBuilder.CreateTable(
- name: "Comments",
- columns: table => new
- {
- Id = table.Column(type: "integer", nullable: false)
- .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
- Content = table.Column(type: "text", nullable: false),
- CreatedAt = table.Column(type: "timestamp with time zone", nullable: false),
- UpdatedAt = table.Column(type: "timestamp with time zone", nullable: false),
- UserId = table.Column(type: "integer", nullable: false),
- StoryId = table.Column(type: "integer", nullable: false)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_Comments", x => x.Id);
- table.ForeignKey(
- name: "FK_Comments_Stories_StoryId",
- column: x => x.StoryId,
- principalTable: "Stories",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- table.ForeignKey(
- name: "FK_Comments_Users_UserId",
- column: x => x.UserId,
- principalTable: "Users",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- });
-
- migrationBuilder.CreateTable(
- name: "HasGenres",
- columns: table => new
- {
- Id = table.Column(type: "integer", nullable: false)
- .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
- StoryId = table.Column(type: "integer", nullable: false),
- GenreId = table.Column(type: "integer", nullable: false)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_HasGenres", x => x.Id);
- table.ForeignKey(
- name: "FK_HasGenres_Genres_GenreId",
- column: x => x.GenreId,
- principalTable: "Genres",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- table.ForeignKey(
- name: "FK_HasGenres_Stories_StoryId",
- column: x => x.StoryId,
- principalTable: "Stories",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- });
-
- migrationBuilder.CreateTable(
- name: "Notifies",
- columns: table => new
- {
- Id = table.Column(type: "integer", nullable: false)
- .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
- UserId = table.Column(type: "integer", nullable: false),
- NotificationId = table.Column(type: "integer", nullable: false),
- IsRead = table.Column(type: "boolean", nullable: false),
- StoryId = table.Column(type: "integer", nullable: true)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_Notifies", x => x.Id);
- table.ForeignKey(
- name: "FK_Notifies_Notifications_NotificationId",
- column: x => x.NotificationId,
- principalTable: "Notifications",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- table.ForeignKey(
- name: "FK_Notifies_Stories_StoryId",
- column: x => x.StoryId,
- principalTable: "Stories",
- principalColumn: "Id");
- table.ForeignKey(
- name: "FK_Notifies_Users_UserId",
- column: x => x.UserId,
- principalTable: "Users",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- });
-
- migrationBuilder.CreateTable(
- name: "ReadingListItems",
- columns: table => new
- {
- Id = table.Column(type: "integer", nullable: false)
- .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
- ReadingListId = table.Column(type: "integer", nullable: false),
- StoryId = table.Column(type: "integer", nullable: false),
- AddedAt = table.Column(type: "timestamp with time zone", nullable: false)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_ReadingListItems", x => x.Id);
- table.ForeignKey(
- name: "FK_ReadingListItems_ReadingLists_ReadingListId",
- column: x => x.ReadingListId,
- principalTable: "ReadingLists",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- table.ForeignKey(
- name: "FK_ReadingListItems_Stories_StoryId",
- column: x => x.StoryId,
- principalTable: "Stories",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- });
-
- migrationBuilder.CreateTable(
- name: "Likes",
- columns: table => new
- {
- Id = table.Column(type: "integer", nullable: false)
- .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
- UserId = table.Column(type: "integer", nullable: false),
- ChapterId = table.Column(type: "integer", nullable: false),
- CreatedAt = table.Column(type: "timestamp with time zone", nullable: false),
- StoryId = table.Column(type: "integer", nullable: true)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_Likes", x => x.Id);
- table.ForeignKey(
- name: "FK_Likes_Chapters_ChapterId",
- column: x => x.ChapterId,
- principalTable: "Chapters",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- table.ForeignKey(
- name: "FK_Likes_Stories_StoryId",
- column: x => x.StoryId,
- principalTable: "Stories",
- principalColumn: "Id");
- table.ForeignKey(
- name: "FK_Likes_Users_UserId",
- column: x => x.UserId,
- principalTable: "Users",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- });
-
- migrationBuilder.CreateTable(
- name: "NeedApprovals",
- columns: table => new
- {
- Id = table.Column(type: "integer", nullable: false)
- .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
- StoryId = table.Column(type: "integer", nullable: false),
- AdminId = table.Column(type: "integer", nullable: false),
- Approved = table.Column(type: "boolean", nullable: false),
- RequestedAt = table.Column(type: "timestamp with time zone", nullable: false),
- AISuggestionId = table.Column(type: "integer", nullable: true),
- ChapterId = table.Column(type: "integer", nullable: true)
- },
- constraints: table =>
- {
- table.PrimaryKey("PK_NeedApprovals", x => x.Id);
- table.ForeignKey(
- name: "FK_NeedApprovals_AISuggestions_AISuggestionId",
- column: x => x.AISuggestionId,
- principalTable: "AISuggestions",
- principalColumn: "Id");
- table.ForeignKey(
- name: "FK_NeedApprovals_Admins_AdminId",
- column: x => x.AdminId,
- principalTable: "Admins",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- table.ForeignKey(
- name: "FK_NeedApprovals_Chapters_ChapterId",
- column: x => x.ChapterId,
- principalTable: "Chapters",
- principalColumn: "Id");
- table.ForeignKey(
- name: "FK_NeedApprovals_Stories_StoryId",
- column: x => x.StoryId,
- principalTable: "Stories",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- });
-
- migrationBuilder.CreateIndex(
- name: "IX_Admins_UserId",
- table: "Admins",
- column: "UserId",
- unique: true);
-
- migrationBuilder.CreateIndex(
- name: "IX_AISuggestions_StoryId",
- table: "AISuggestions",
- column: "StoryId");
-
- migrationBuilder.CreateIndex(
- name: "IX_Chapters_StoryId",
- table: "Chapters",
- column: "StoryId");
-
- migrationBuilder.CreateIndex(
- name: "IX_Collaborations_StoryId",
- table: "Collaborations",
- column: "StoryId");
-
- migrationBuilder.CreateIndex(
- name: "IX_Collaborations_UserId",
- table: "Collaborations",
- column: "UserId");
-
- migrationBuilder.CreateIndex(
- name: "IX_Comments_StoryId",
- table: "Comments",
- column: "StoryId");
-
- migrationBuilder.CreateIndex(
- name: "IX_Comments_UserId",
- table: "Comments",
- column: "UserId");
-
- migrationBuilder.CreateIndex(
- name: "IX_HasGenres_GenreId",
- table: "HasGenres",
- column: "GenreId");
-
- migrationBuilder.CreateIndex(
- name: "IX_HasGenres_StoryId",
- table: "HasGenres",
- column: "StoryId");
-
- migrationBuilder.CreateIndex(
- name: "IX_Likes_ChapterId",
- table: "Likes",
- column: "ChapterId");
-
- migrationBuilder.CreateIndex(
- name: "IX_Likes_StoryId",
- table: "Likes",
- column: "StoryId");
-
- migrationBuilder.CreateIndex(
- name: "IX_Likes_UserId",
- table: "Likes",
- column: "UserId");
-
- migrationBuilder.CreateIndex(
- name: "IX_NeedApprovals_AdminId",
- table: "NeedApprovals",
- column: "AdminId");
-
- migrationBuilder.CreateIndex(
- name: "IX_NeedApprovals_AISuggestionId",
- table: "NeedApprovals",
- column: "AISuggestionId");
-
- migrationBuilder.CreateIndex(
- name: "IX_NeedApprovals_ChapterId",
- table: "NeedApprovals",
- column: "ChapterId");
-
- migrationBuilder.CreateIndex(
- name: "IX_NeedApprovals_StoryId",
- table: "NeedApprovals",
- column: "StoryId");
-
- migrationBuilder.CreateIndex(
- name: "IX_Notifies_NotificationId",
- table: "Notifies",
- column: "NotificationId");
-
- migrationBuilder.CreateIndex(
- name: "IX_Notifies_StoryId",
- table: "Notifies",
- column: "StoryId");
-
- migrationBuilder.CreateIndex(
- name: "IX_Notifies_UserId",
- table: "Notifies",
- column: "UserId");
-
- migrationBuilder.CreateIndex(
- name: "IX_ReadingListItems_ReadingListId",
- table: "ReadingListItems",
- column: "ReadingListId");
-
- migrationBuilder.CreateIndex(
- name: "IX_ReadingListItems_StoryId",
- table: "ReadingListItems",
- column: "StoryId");
-
- migrationBuilder.CreateIndex(
- name: "IX_ReadingLists_UserId",
- table: "ReadingLists",
- column: "UserId");
-
- migrationBuilder.CreateIndex(
- name: "IX_RegularUsers_UserId",
- table: "RegularUsers",
- column: "UserId",
- unique: true);
-
- migrationBuilder.CreateIndex(
- name: "IX_Stories_WriterId",
- table: "Stories",
- column: "WriterId");
-
- migrationBuilder.CreateIndex(
- name: "IX_Writers_UserId",
- table: "Writers",
- column: "UserId",
- unique: true);
- }
-
- ///
- protected override void Down(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.DropTable(
- name: "Collaborations");
-
- migrationBuilder.DropTable(
- name: "Comments");
-
- migrationBuilder.DropTable(
- name: "HasGenres");
-
- migrationBuilder.DropTable(
- name: "Likes");
-
- migrationBuilder.DropTable(
- name: "NeedApprovals");
-
- migrationBuilder.DropTable(
- name: "Notifies");
-
- migrationBuilder.DropTable(
- name: "ReadingListItems");
-
- migrationBuilder.DropTable(
- name: "RegularUsers");
-
- migrationBuilder.DropTable(
- name: "Genres");
-
- migrationBuilder.DropTable(
- name: "AISuggestions");
-
- migrationBuilder.DropTable(
- name: "Admins");
-
- migrationBuilder.DropTable(
- name: "Chapters");
-
- migrationBuilder.DropTable(
- name: "Notifications");
-
- migrationBuilder.DropTable(
- name: "ReadingLists");
-
- migrationBuilder.DropTable(
- name: "Stories");
-
- migrationBuilder.DropTable(
- name: "Writers");
-
- migrationBuilder.DropTable(
- name: "Users");
- }
- }
-}
Index: ChapterX.Infrastructure/Migrations/20260319165534_InitialCreate1.Designer.cs
===================================================================
--- ChapterX.Infrastructure/Migrations/20260319165534_InitialCreate1.Designer.cs (revision b62cefc14094ca5ac7154f7d48797a1e6c444935)
+++ (revision )
@@ -1,852 +1,0 @@
-//
-using System;
-using ChapterX.Infrastructure.Data.DataContext;
-using Microsoft.EntityFrameworkCore;
-using Microsoft.EntityFrameworkCore.Infrastructure;
-using Microsoft.EntityFrameworkCore.Migrations;
-using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
-using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
-
-#nullable disable
-
-namespace ChapterX.Infrastructure.Migrations
-{
- [DbContext(typeof(ApplicationDbContext))]
- [Migration("20260319165534_InitialCreate1")]
- partial class InitialCreate1
- {
- ///
- protected override void BuildTargetModel(ModelBuilder modelBuilder)
- {
-#pragma warning disable 612, 618
- modelBuilder
- .HasAnnotation("ProductVersion", "9.0.1")
- .HasAnnotation("Relational:MaxIdentifierLength", 63);
-
- NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder);
-
- modelBuilder.Entity("ChapterX.Domain.Entities.AISuggestion", b =>
- {
- b.Property("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("integer");
-
- NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id"));
-
- b.Property("Accepted")
- .HasColumnType("boolean");
-
- b.Property("AppliedAt")
- .HasColumnType("timestamp with time zone");
-
- b.Property("CreatedAt")
- .HasColumnType("timestamp with time zone");
-
- b.Property("OriginalText")
- .IsRequired()
- .HasColumnType("text");
-
- b.Property("StoryId")
- .HasColumnType("integer");
-
- b.Property("SuggestedText")
- .IsRequired()
- .HasColumnType("text");
-
- b.PrimitiveCollection("SuggestionTypes")
- .IsRequired()
- .HasColumnType("integer[]");
-
- b.HasKey("Id");
-
- b.HasIndex("StoryId");
-
- b.ToTable("AISuggestions");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.Admin", b =>
- {
- b.Property("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("integer");
-
- NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id"));
-
- b.Property("UserId")
- .HasColumnType("integer");
-
- b.HasKey("Id");
-
- b.HasIndex("UserId")
- .IsUnique();
-
- b.ToTable("Admins");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.Chapter", b =>
- {
- b.Property("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("integer");
-
- NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id"));
-
- b.Property("Content")
- .IsRequired()
- .HasColumnType("text");
-
- b.Property("CreatedAt")
- .HasColumnType("timestamp with time zone");
-
- b.Property("Name")
- .IsRequired()
- .HasColumnType("text");
-
- b.Property("Number")
- .HasColumnType("integer");
-
- b.Property("PublishedAt")
- .HasColumnType("timestamp with time zone");
-
- b.Property("Rating")
- .HasColumnType("numeric");
-
- b.Property("StoryId")
- .HasColumnType("integer");
-
- b.Property("Title")
- .IsRequired()
- .HasColumnType("text");
-
- b.Property("UpdatedAt")
- .HasColumnType("timestamp with time zone");
-
- b.Property("ViewCount")
- .HasColumnType("integer");
-
- b.Property("WordCount")
- .HasColumnType("integer");
-
- b.HasKey("Id");
-
- b.HasIndex("StoryId");
-
- b.ToTable("Chapters");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.Collaboration", b =>
- {
- b.Property("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("integer");
-
- NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id"));
-
- b.Property("JoinedAt")
- .HasColumnType("timestamp with time zone");
-
- b.Property("Role")
- .IsRequired()
- .HasColumnType("text");
-
- b.Property("StoryId")
- .HasColumnType("integer");
-
- b.Property("UserId")
- .HasColumnType("integer");
-
- b.HasKey("Id");
-
- b.HasIndex("StoryId");
-
- b.HasIndex("UserId");
-
- b.ToTable("Collaborations");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.Comment", b =>
- {
- b.Property("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("integer");
-
- NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id"));
-
- b.Property("Content")
- .IsRequired()
- .HasColumnType("text");
-
- b.Property("CreatedAt")
- .HasColumnType("timestamp with time zone");
-
- b.Property("StoryId")
- .HasColumnType("integer");
-
- b.Property("UpdatedAt")
- .HasColumnType("timestamp with time zone");
-
- b.Property("UserId")
- .HasColumnType("integer");
-
- b.HasKey("Id");
-
- b.HasIndex("StoryId");
-
- b.HasIndex("UserId");
-
- b.ToTable("Comments");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.Genre", b =>
- {
- b.Property("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("integer");
-
- NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id"));
-
- b.Property("Name")
- .IsRequired()
- .HasColumnType("text");
-
- b.HasKey("Id");
-
- b.ToTable("Genres");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.HasGenre", b =>
- {
- b.Property("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("integer");
-
- NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id"));
-
- b.Property("GenreId")
- .HasColumnType("integer");
-
- b.Property("StoryId")
- .HasColumnType("integer");
-
- b.HasKey("Id");
-
- b.HasIndex("GenreId");
-
- b.HasIndex("StoryId");
-
- b.ToTable("HasGenres");
- });
-
- modelBuilder.Entity("ChapterX.Domain.Entities.Likes", b =>
- {
- b.Property("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("integer");
-
- NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id"));
-
- b.Property("ChapterId")
- .HasColumnType("integer");
-
- b.Property