From fdca6a03fe4733c739a724a902fa9fe0b0b55edc Mon Sep 17 00:00:00 2001 From: 杨宇千 Date: Mon, 19 Aug 2019 16:03:47 +0800 Subject: Add migration. --- .../Migrations/DatabaseContextModelSnapshot.cs | 23 ++++++++++++---------- 1 file changed, 13 insertions(+), 10 deletions(-) (limited to 'Timeline/Migrations/DatabaseContextModelSnapshot.cs') diff --git a/Timeline/Migrations/DatabaseContextModelSnapshot.cs b/Timeline/Migrations/DatabaseContextModelSnapshot.cs index 152bdea4..de96dc40 100644 --- a/Timeline/Migrations/DatabaseContextModelSnapshot.cs +++ b/Timeline/Migrations/DatabaseContextModelSnapshot.cs @@ -23,8 +23,6 @@ namespace Timeline.Migrations .ValueGeneratedOnAdd() .HasColumnName("id"); - b.Property("AvatarId"); - b.Property("EncryptedPassword") .IsRequired() .HasColumnName("password"); @@ -45,8 +43,6 @@ namespace Timeline.Migrations b.HasKey("Id"); - b.HasIndex("AvatarId"); - b.ToTable("users"); }); @@ -57,23 +53,30 @@ namespace Timeline.Migrations .HasColumnName("id"); b.Property("Data") - .IsRequired() .HasColumnName("data"); + b.Property("LastModified") + .HasColumnName("last_modified"); + b.Property("Type") - .IsRequired() .HasColumnName("type"); + b.Property("UserId"); + b.HasKey("Id"); + b.HasIndex("UserId") + .IsUnique(); + b.ToTable("user_avatars"); }); - modelBuilder.Entity("Timeline.Entities.User", b => + modelBuilder.Entity("Timeline.Entities.UserAvatar", b => { - b.HasOne("Timeline.Entities.UserAvatar", "Avatar") - .WithMany() - .HasForeignKey("AvatarId"); + b.HasOne("Timeline.Entities.User") + .WithOne("Avatar") + .HasForeignKey("Timeline.Entities.UserAvatar", "UserId") + .OnDelete(DeleteBehavior.Cascade); }); #pragma warning restore 612, 618 } -- cgit v1.2.3 From 79e578e97ed252bff0dca3c89d81a395b35289d7 Mon Sep 17 00:00:00 2001 From: 杨宇千 Date: Mon, 19 Aug 2019 16:09:11 +0800 Subject: Add index for username. --- Timeline/Entities/DatabaseContext.cs | 1 + Timeline/Entities/UserAvatar.cs | 1 - .../20190819080823_AddIndexForUserName.Designer.cs | 88 ++++++++++++++++++++++ .../20190819080823_AddIndexForUserName.cs | 22 ++++++ .../Migrations/DatabaseContextModelSnapshot.cs | 2 + 5 files changed, 113 insertions(+), 1 deletion(-) create mode 100644 Timeline/Migrations/20190819080823_AddIndexForUserName.Designer.cs create mode 100644 Timeline/Migrations/20190819080823_AddIndexForUserName.cs (limited to 'Timeline/Migrations/DatabaseContextModelSnapshot.cs') diff --git a/Timeline/Entities/DatabaseContext.cs b/Timeline/Entities/DatabaseContext.cs index b12db46e..bc06b9df 100644 --- a/Timeline/Entities/DatabaseContext.cs +++ b/Timeline/Entities/DatabaseContext.cs @@ -43,6 +43,7 @@ namespace Timeline.Entities protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.Entity().Property(e => e.Version).HasDefaultValue(0); + modelBuilder.Entity().HasIndex(e => e.Name); } public DbSet Users { get; set; } diff --git a/Timeline/Entities/UserAvatar.cs b/Timeline/Entities/UserAvatar.cs index a2fd6821..b941445d 100644 --- a/Timeline/Entities/UserAvatar.cs +++ b/Timeline/Entities/UserAvatar.cs @@ -1,7 +1,6 @@ using System; using System.ComponentModel.DataAnnotations; using System.ComponentModel.DataAnnotations.Schema; -using Timeline.Services; namespace Timeline.Entities { diff --git a/Timeline/Migrations/20190819080823_AddIndexForUserName.Designer.cs b/Timeline/Migrations/20190819080823_AddIndexForUserName.Designer.cs new file mode 100644 index 00000000..d45a057d --- /dev/null +++ b/Timeline/Migrations/20190819080823_AddIndexForUserName.Designer.cs @@ -0,0 +1,88 @@ +// +using System; +using Microsoft.EntityFrameworkCore; +using Microsoft.EntityFrameworkCore.Infrastructure; +using Microsoft.EntityFrameworkCore.Migrations; +using Microsoft.EntityFrameworkCore.Storage.ValueConversion; +using Timeline.Entities; + +namespace Timeline.Migrations +{ + [DbContext(typeof(DatabaseContext))] + [Migration("20190819080823_AddIndexForUserName")] + partial class AddIndexForUserName + { + protected override void BuildTargetModel(ModelBuilder modelBuilder) + { +#pragma warning disable 612, 618 + modelBuilder + .HasAnnotation("ProductVersion", "2.2.6-servicing-10079") + .HasAnnotation("Relational:MaxIdentifierLength", 64); + + modelBuilder.Entity("Timeline.Entities.User", b => + { + b.Property("Id") + .ValueGeneratedOnAdd() + .HasColumnName("id"); + + b.Property("EncryptedPassword") + .IsRequired() + .HasColumnName("password"); + + b.Property("Name") + .IsRequired() + .HasColumnName("name") + .HasMaxLength(26); + + b.Property("RoleString") + .IsRequired() + .HasColumnName("roles"); + + b.Property("Version") + .ValueGeneratedOnAdd() + .HasColumnName("version") + .HasDefaultValue(0L); + + b.HasKey("Id"); + + b.HasIndex("Name"); + + b.ToTable("users"); + }); + + modelBuilder.Entity("Timeline.Entities.UserAvatar", b => + { + b.Property("Id") + .ValueGeneratedOnAdd() + .HasColumnName("id"); + + b.Property("Data") + .HasColumnName("data"); + + b.Property("LastModified") + .HasColumnName("last_modified"); + + b.Property("Type") + .HasColumnName("type"); + + b.Property("UserId"); + + b.HasKey("Id"); + + b.HasIndex("UserId") + .IsUnique(); + + b.ToTable("user_avatars"); + }); + + modelBuilder.Entity("Timeline.Entities.UserAvatar", b => + { + b.HasOne("Timeline.Entities.User") + .WithOne("Avatar") + .HasForeignKey("Timeline.Entities.UserAvatar", "UserId") + .OnDelete(DeleteBehavior.Cascade); + }); +#pragma warning restore 612, 618 + } + } +} diff --git a/Timeline/Migrations/20190819080823_AddIndexForUserName.cs b/Timeline/Migrations/20190819080823_AddIndexForUserName.cs new file mode 100644 index 00000000..b910a174 --- /dev/null +++ b/Timeline/Migrations/20190819080823_AddIndexForUserName.cs @@ -0,0 +1,22 @@ +using Microsoft.EntityFrameworkCore.Migrations; + +namespace Timeline.Migrations +{ + public partial class AddIndexForUserName : Migration + { + protected override void Up(MigrationBuilder migrationBuilder) + { + migrationBuilder.CreateIndex( + name: "IX_users_name", + table: "users", + column: "name"); + } + + protected override void Down(MigrationBuilder migrationBuilder) + { + migrationBuilder.DropIndex( + name: "IX_users_name", + table: "users"); + } + } +} diff --git a/Timeline/Migrations/DatabaseContextModelSnapshot.cs b/Timeline/Migrations/DatabaseContextModelSnapshot.cs index de96dc40..0eb85997 100644 --- a/Timeline/Migrations/DatabaseContextModelSnapshot.cs +++ b/Timeline/Migrations/DatabaseContextModelSnapshot.cs @@ -43,6 +43,8 @@ namespace Timeline.Migrations b.HasKey("Id"); + b.HasIndex("Name"); + b.ToTable("users"); }); -- cgit v1.2.3