From ba7d166578c540a5ab7c9912c77146a2012dc3ec Mon Sep 17 00:00:00 2001 From: crupest Date: Wed, 20 Nov 2019 18:48:14 +0800 Subject: Update packages and migrate database. --- .../Migrations/DatabaseContextModelSnapshot.cs | 147 ++++++++++++++++++++- 1 file changed, 140 insertions(+), 7 deletions(-) (limited to 'Timeline/Migrations/DatabaseContextModelSnapshot.cs') diff --git a/Timeline/Migrations/DatabaseContextModelSnapshot.cs b/Timeline/Migrations/DatabaseContextModelSnapshot.cs index 697fbbec..26be281c 100644 --- a/Timeline/Migrations/DatabaseContextModelSnapshot.cs +++ b/Timeline/Migrations/DatabaseContextModelSnapshot.cs @@ -14,9 +14,103 @@ namespace Timeline.Migrations { #pragma warning disable 612, 618 modelBuilder - .HasAnnotation("ProductVersion", "3.0.0") + .HasAnnotation("ProductVersion", "3.0.1") .HasAnnotation("Relational:MaxIdentifierLength", 64); + modelBuilder.Entity("Timeline.Entities.TimelineEntity", b => + { + b.Property("Id") + .ValueGeneratedOnAdd() + .HasColumnName("id") + .HasColumnType("bigint"); + + b.Property("CreateTime") + .HasColumnName("create_time") + .HasColumnType("datetime(6)"); + + b.Property("Description") + .HasColumnName("description") + .HasColumnType("longtext CHARACTER SET utf8mb4"); + + b.Property("Name") + .HasColumnName("name") + .HasColumnType("longtext CHARACTER SET utf8mb4"); + + b.Property("OwnerId") + .HasColumnName("owner") + .HasColumnType("bigint"); + + b.Property("Visibility") + .HasColumnName("visibility") + .HasColumnType("int"); + + b.HasKey("Id"); + + b.HasIndex("OwnerId"); + + b.ToTable("timelines"); + }); + + modelBuilder.Entity("Timeline.Entities.TimelineMemberEntity", b => + { + b.Property("Id") + .ValueGeneratedOnAdd() + .HasColumnName("id") + .HasColumnType("bigint"); + + b.Property("TimelineId") + .HasColumnName("timeline") + .HasColumnType("bigint"); + + b.Property("UserId") + .HasColumnName("user") + .HasColumnType("bigint"); + + b.HasKey("Id"); + + b.HasIndex("TimelineId"); + + b.HasIndex("UserId"); + + b.ToTable("TimelineMembers"); + }); + + modelBuilder.Entity("Timeline.Entities.TimelinePostEntity", b => + { + b.Property("Id") + .ValueGeneratedOnAdd() + .HasColumnName("id") + .HasColumnType("bigint"); + + b.Property("AuthorId") + .HasColumnName("author") + .HasColumnType("bigint"); + + b.Property("Content") + .HasColumnName("content") + .HasColumnType("longtext CHARACTER SET utf8mb4"); + + b.Property("LastUpdated") + .HasColumnName("last_updated") + .HasColumnType("datetime(6)"); + + b.Property("Time") + .HasColumnName("time") + .HasColumnType("datetime(6)"); + + b.Property("TimelineId") + .HasColumnName("timeline") + .HasColumnType("bigint"); + + b.HasKey("Id"); + + b.HasIndex("AuthorId"); + + b.HasIndex("TimelineId"); + + b.ToTable("timeline_posts"); + }); + modelBuilder.Entity("Timeline.Entities.User", b => { b.Property("Id") @@ -27,18 +121,18 @@ namespace Timeline.Migrations b.Property("EncryptedPassword") .IsRequired() .HasColumnName("password") - .HasColumnType("longtext"); + .HasColumnType("longtext CHARACTER SET utf8mb4"); b.Property("Name") .IsRequired() .HasColumnName("name") - .HasColumnType("varchar(26)") + .HasColumnType("varchar(26) CHARACTER SET utf8mb4") .HasMaxLength(26); b.Property("RoleString") .IsRequired() .HasColumnName("roles") - .HasColumnType("longtext"); + .HasColumnType("longtext CHARACTER SET utf8mb4"); b.Property("Version") .ValueGeneratedOnAdd() @@ -67,7 +161,7 @@ namespace Timeline.Migrations b.Property("ETag") .HasColumnName("etag") - .HasColumnType("varchar(30)") + .HasColumnType("varchar(30) CHARACTER SET utf8mb4") .HasMaxLength(30); b.Property("LastModified") @@ -76,7 +170,7 @@ namespace Timeline.Migrations b.Property("Type") .HasColumnName("type") - .HasColumnType("longtext"); + .HasColumnType("longtext CHARACTER SET utf8mb4"); b.Property("UserId") .HasColumnType("bigint"); @@ -98,7 +192,7 @@ namespace Timeline.Migrations b.Property("Nickname") .HasColumnName("nickname") - .HasColumnType("varchar(26)") + .HasColumnType("varchar(26) CHARACTER SET utf8mb4") .HasMaxLength(26); b.Property("UserId") @@ -112,6 +206,45 @@ namespace Timeline.Migrations b.ToTable("user_details"); }); + modelBuilder.Entity("Timeline.Entities.TimelineEntity", b => + { + b.HasOne("Timeline.Entities.User", "Owner") + .WithMany("Timelines") + .HasForeignKey("OwnerId") + .OnDelete(DeleteBehavior.Cascade) + .IsRequired(); + }); + + modelBuilder.Entity("Timeline.Entities.TimelineMemberEntity", b => + { + b.HasOne("Timeline.Entities.TimelineEntity", "Timeline") + .WithMany("Members") + .HasForeignKey("TimelineId") + .OnDelete(DeleteBehavior.Cascade) + .IsRequired(); + + b.HasOne("Timeline.Entities.User", "User") + .WithMany("TimelinesJoined") + .HasForeignKey("UserId") + .OnDelete(DeleteBehavior.Cascade) + .IsRequired(); + }); + + modelBuilder.Entity("Timeline.Entities.TimelinePostEntity", b => + { + b.HasOne("Timeline.Entities.User", "Author") + .WithMany("TimelinePosts") + .HasForeignKey("AuthorId") + .OnDelete(DeleteBehavior.Cascade) + .IsRequired(); + + b.HasOne("Timeline.Entities.TimelineEntity", "Timeline") + .WithMany("Posts") + .HasForeignKey("TimelineId") + .OnDelete(DeleteBehavior.Cascade) + .IsRequired(); + }); + modelBuilder.Entity("Timeline.Entities.UserAvatar", b => { b.HasOne("Timeline.Entities.User", null) -- cgit v1.2.3