Merge pull request #59 from crupest/dev

Migrate to sqlite.

15 files changed, 121 insertions, 1458 deletions

diff --git a/Timeline/Migrations/DevelopmentDatabase/20200105150407_Initialize.Designer.cs b/Timeline/Migrations/20200105150407_Initialize.Designer.cs
index 6fe1044c..ca93fcb3 100644
--- a/Timeline/Migrations/DevelopmentDatabase/20200105150407_Initialize.Designer.cs
+++ b/Timeline/Migrations/20200105150407_Initialize.Designer.cs
@@ -6,9 +6,9 @@ using Microsoft.EntityFrameworkCore.Migrations;
 using Microsoft.EntityFrameworkCore.Storage.ValueConversion;

 using Timeline.Entities;

 

-namespace Timeline.Migrations.DevelopmentDatabase

+namespace Timeline.Migrations

 {

-    [DbContext(typeof(DevelopmentDatabaseContext))]

+    [DbContext(typeof(DatabaseContext))]

     [Migration("20200105150407_Initialize")]

     partial class Initialize

     {

diff --git a/Timeline/Migrations/DevelopmentDatabase/20200105150407_Initialize.cs b/Timeline/Migrations/20200105150407_Initialize.cs
index c6efaa4b..2881ee64 100644
--- a/Timeline/Migrations/DevelopmentDatabase/20200105150407_Initialize.cs
+++ b/Timeline/Migrations/20200105150407_Initialize.cs
@@ -1,7 +1,7 @@
 using System;

 using Microsoft.EntityFrameworkCore.Migrations;

 

-namespace Timeline.Migrations.DevelopmentDatabase

+namespace Timeline.Migrations

 {

     public partial class Initialize : Migration

     {

diff --git a/Timeline/Migrations/DevelopmentDatabase/20200131100517_RefactorUser.Designer.cs b/Timeline/Migrations/20200131100517_RefactorUser.Designer.cs
index 13e322c8..fb5e8a30 100644
--- a/Timeline/Migrations/DevelopmentDatabase/20200131100517_RefactorUser.Designer.cs
+++ b/Timeline/Migrations/20200131100517_RefactorUser.Designer.cs
@@ -6,9 +6,9 @@ using Microsoft.EntityFrameworkCore.Migrations;
 using Microsoft.EntityFrameworkCore.Storage.ValueConversion;

 using Timeline.Entities;

 

-namespace Timeline.Migrations.DevelopmentDatabase

+namespace Timeline.Migrations

 {

-    [DbContext(typeof(DevelopmentDatabaseContext))]

+    [DbContext(typeof(DatabaseContext))]

     [Migration("20200131100517_RefactorUser")]

     partial class RefactorUser

     {

diff --git a/Timeline/Migrations/DevelopmentDatabase/20200131100517_RefactorUser.cs b/Timeline/Migrations/20200131100517_RefactorUser.cs
index ade65eb1..533f4bc4 100644
--- a/Timeline/Migrations/DevelopmentDatabase/20200131100517_RefactorUser.cs
+++ b/Timeline/Migrations/20200131100517_RefactorUser.cs
@@ -1,6 +1,6 @@
 using Microsoft.EntityFrameworkCore.Migrations;

 

-namespace Timeline.Migrations.DevelopmentDatabase

+namespace Timeline.Migrations

 {

     public partial class RefactorUser : Migration

     {

diff --git a/Timeline/Migrations/ProductionDatabase/20200131152033_RefactorUser.Designer.cs b/Timeline/Migrations/20200221064341_AddJwtToken.Designer.cs
index bb0bb5af..56596249 100644
--- a/Timeline/Migrations/ProductionDatabase/20200131152033_RefactorUser.Designer.cs
+++ b/Timeline/Migrations/20200221064341_AddJwtToken.Designer.cs
@@ -6,45 +6,61 @@ using Microsoft.EntityFrameworkCore.Migrations;
 using Microsoft.EntityFrameworkCore.Storage.ValueConversion;

 using Timeline.Entities;

 

-namespace Timeline.Migrations.ProductionDatabase

+namespace Timeline.Migrations

 {

-    [DbContext(typeof(ProductionDatabaseContext))]

-    [Migration("20200131152033_RefactorUser")]

-    partial class RefactorUser

+    [DbContext(typeof(DatabaseContext))]

+    [Migration("20200221064341_AddJwtToken")]

+    partial class AddJwtToken

     {

         protected override void BuildTargetModel(ModelBuilder modelBuilder)

         {

 #pragma warning disable 612, 618

             modelBuilder

-                .HasAnnotation("ProductVersion", "3.1.1")

-                .HasAnnotation("Relational:MaxIdentifierLength", 64);

+                .HasAnnotation("ProductVersion", "3.1.2");

+

+            modelBuilder.Entity("Timeline.Entities.JwtTokenEntity", b =>

+                {

+                    b.Property<long>("Id")

+                        .ValueGeneratedOnAdd()

+                        .HasColumnName("id")

+                        .HasColumnType("INTEGER");

+

+                    b.Property<byte[]>("Token")

+                        .IsRequired()

+                        .HasColumnName("token")

+                        .HasColumnType("BLOB");

+

+                    b.HasKey("Id");

+

+                    b.ToTable("jwt_token");

+                });

 

             modelBuilder.Entity("Timeline.Entities.TimelineEntity", b =>

                 {

                     b.Property<long>("Id")

                         .ValueGeneratedOnAdd()

                         .HasColumnName("id")

-                        .HasColumnType("bigint");

+                        .HasColumnType("INTEGER");

 

                     b.Property<DateTime>("CreateTime")

                         .HasColumnName("create_time")

-                        .HasColumnType("datetime(6)");

+                        .HasColumnType("TEXT");

 

                     b.Property<string>("Description")

                         .HasColumnName("description")

-                        .HasColumnType("longtext CHARACTER SET utf8mb4");

+                        .HasColumnType("TEXT");

 

                     b.Property<string>("Name")

                         .HasColumnName("name")

-                        .HasColumnType("longtext CHARACTER SET utf8mb4");

+                        .HasColumnType("TEXT");

 

                     b.Property<long>("OwnerId")

                         .HasColumnName("owner")

-                        .HasColumnType("bigint");

+                        .HasColumnType("INTEGER");

 

                     b.Property<int>("Visibility")

                         .HasColumnName("visibility")

-                        .HasColumnType("int");

+                        .HasColumnType("INTEGER");

 

                     b.HasKey("Id");

 

@@ -58,15 +74,15 @@ namespace Timeline.Migrations.ProductionDatabase
                     b.Property<long>("Id")

                         .ValueGeneratedOnAdd()

                         .HasColumnName("id")

-                        .HasColumnType("bigint");

+                        .HasColumnType("INTEGER");

 

                     b.Property<long>("TimelineId")

                         .HasColumnName("timeline")

-                        .HasColumnType("bigint");

+                        .HasColumnType("INTEGER");

 

                     b.Property<long>("UserId")

                         .HasColumnName("user")

-                        .HasColumnType("bigint");

+                        .HasColumnType("INTEGER");

 

                     b.HasKey("Id");

 

@@ -82,27 +98,27 @@ namespace Timeline.Migrations.ProductionDatabase
                     b.Property<long>("Id")

                         .ValueGeneratedOnAdd()

                         .HasColumnName("id")

-                        .HasColumnType("bigint");

+                        .HasColumnType("INTEGER");

 

                     b.Property<long>("AuthorId")

                         .HasColumnName("author")

-                        .HasColumnType("bigint");

+                        .HasColumnType("INTEGER");

 

                     b.Property<string>("Content")

                         .HasColumnName("content")

-                        .HasColumnType("longtext CHARACTER SET utf8mb4");

+                        .HasColumnType("TEXT");

 

                     b.Property<DateTime>("LastUpdated")

                         .HasColumnName("last_updated")

-                        .HasColumnType("datetime(6)");

+                        .HasColumnType("TEXT");

 

                     b.Property<DateTime>("Time")

                         .HasColumnName("time")

-                        .HasColumnType("datetime(6)");

+                        .HasColumnType("TEXT");

 

                     b.Property<long>("TimelineId")

                         .HasColumnName("timeline")

-                        .HasColumnType("bigint");

+                        .HasColumnType("INTEGER");

 

                     b.HasKey("Id");

 

@@ -118,28 +134,28 @@ namespace Timeline.Migrations.ProductionDatabase
                     b.Property<long>("Id")

                         .ValueGeneratedOnAdd()

                         .HasColumnName("id")

-                        .HasColumnType("bigint");

+                        .HasColumnType("INTEGER");

 

                     b.Property<byte[]>("Data")

                         .HasColumnName("data")

-                        .HasColumnType("longblob");

+                        .HasColumnType("BLOB");

 

                     b.Property<string>("ETag")

                         .HasColumnName("etag")

-                        .HasColumnType("varchar(30) CHARACTER SET utf8mb4")

+                        .HasColumnType("TEXT")

                         .HasMaxLength(30);

 

                     b.Property<DateTime>("LastModified")

                         .HasColumnName("last_modified")

-                        .HasColumnType("datetime(6)");

+                        .HasColumnType("TEXT");

 

                     b.Property<string>("Type")

                         .HasColumnName("type")

-                        .HasColumnType("longtext CHARACTER SET utf8mb4");

+                        .HasColumnType("TEXT");

 

                     b.Property<long>("UserId")

                         .HasColumnName("user")

-                        .HasColumnType("bigint");

+                        .HasColumnType("INTEGER");

 

                     b.HasKey("Id");

 

@@ -154,33 +170,33 @@ namespace Timeline.Migrations.ProductionDatabase
                     b.Property<long>("Id")

                         .ValueGeneratedOnAdd()

                         .HasColumnName("id")

-                        .HasColumnType("bigint");

+                        .HasColumnType("INTEGER");

 

                     b.Property<string>("Nickname")

                         .HasColumnName("nickname")

-                        .HasColumnType("varchar(100) CHARACTER SET utf8mb4")

+                        .HasColumnType("TEXT")

                         .HasMaxLength(100);

 

                     b.Property<string>("Password")

                         .IsRequired()

                         .HasColumnName("password")

-                        .HasColumnType("longtext CHARACTER SET utf8mb4");

+                        .HasColumnType("TEXT");

 

                     b.Property<string>("Roles")

                         .IsRequired()

                         .HasColumnName("roles")

-                        .HasColumnType("longtext CHARACTER SET utf8mb4");

+                        .HasColumnType("TEXT");

 

                     b.Property<string>("Username")

                         .IsRequired()

                         .HasColumnName("username")

-                        .HasColumnType("varchar(26) CHARACTER SET utf8mb4")

+                        .HasColumnType("TEXT")

                         .HasMaxLength(26);

 

                     b.Property<long>("Version")

                         .ValueGeneratedOnAdd()

                         .HasColumnName("version")

-                        .HasColumnType("bigint")

+                        .HasColumnType("INTEGER")

                         .HasDefaultValue(0L);

 

                     b.HasKey("Id");

diff --git a/Timeline/Migrations/20200221064341_AddJwtToken.cs b/Timeline/Migrations/20200221064341_AddJwtToken.cs
new file mode 100644
index 00000000..628970c6
--- /dev/null
+++ b/Timeline/Migrations/20200221064341_AddJwtToken.cs
@@ -0,0 +1,45 @@
+using System;

+using System.Security.Cryptography;

+using Microsoft.EntityFrameworkCore.Migrations;

+

+namespace Timeline.Migrations

+{

+    public static class JwtTokenGenerateHelper

+    {

+        public static byte[] GenerateKey()

+        {

+            using var random = RandomNumberGenerator.Create();

+            var key = new byte[16];

+            random.GetBytes(key);

+            return key;

+        }

+    }

+

+    public partial class AddJwtToken : Migration

+    {

+        protected override void Up(MigrationBuilder migrationBuilder)

+        {

+            migrationBuilder.CreateTable(

+                name: "jwt_token",

+                columns: table => new

+                {

+                    id = table.Column<long>(nullable: false)

+                        .Annotation("Sqlite:Autoincrement", true),

+                    key = table.Column<byte[]>(nullable: false)

+                },

+                constraints: table =>

+                {

+                    table.PrimaryKey("PK_jwt_token", x => x.id);

+                });

+

+

+            migrationBuilder.InsertData("jwt_token", "key", JwtTokenGenerateHelper.GenerateKey());

+        }

+

+        protected override void Down(MigrationBuilder migrationBuilder)

+        {

+            migrationBuilder.DropTable(

+                name: "jwt_token");

+        }

+    }

+}

diff --git a/Timeline/Migrations/DevelopmentDatabase/DevelopmentDatabaseContextModelSnapshot.cs b/Timeline/Migrations/DatabaseContextModelSnapshot.cs
index 5da49dbe..d5f9c0e4 100644
--- a/Timeline/Migrations/DevelopmentDatabase/DevelopmentDatabaseContextModelSnapshot.cs
+++ b/Timeline/Migrations/DatabaseContextModelSnapshot.cs
@@ -5,16 +5,33 @@ using Microsoft.EntityFrameworkCore.Infrastructure;
 using Microsoft.EntityFrameworkCore.Storage.ValueConversion;

 using Timeline.Entities;

 

-namespace Timeline.Migrations.DevelopmentDatabase

+namespace Timeline.Migrations

 {

-    [DbContext(typeof(DevelopmentDatabaseContext))]

-    partial class DevelopmentDatabaseContextModelSnapshot : ModelSnapshot

+    [DbContext(typeof(DatabaseContext))]

+    partial class DatabaseContextModelSnapshot : ModelSnapshot

     {

         protected override void BuildModel(ModelBuilder modelBuilder)

         {

 #pragma warning disable 612, 618

             modelBuilder

-                .HasAnnotation("ProductVersion", "3.1.1");

+                .HasAnnotation("ProductVersion", "3.1.2");

+

+            modelBuilder.Entity("Timeline.Entities.JwtTokenEntity", b =>

+                {

+                    b.Property<long>("Id")

+                        .ValueGeneratedOnAdd()

+                        .HasColumnName("id")

+                        .HasColumnType("INTEGER");

+

+                    b.Property<byte[]>("Token")

+                        .IsRequired()

+                        .HasColumnName("token")

+                        .HasColumnType("BLOB");

+

+                    b.HasKey("Id");

+

+                    b.ToTable("jwt_token");

+                });

 

             modelBuilder.Entity("Timeline.Entities.TimelineEntity", b =>

                 {

diff --git a/Timeline/Migrations/ProductionDatabase/20191031064541_Initialize.Designer.cs b/Timeline/Migrations/ProductionDatabase/20191031064541_Initialize.Designer.cs
deleted file mode 100644
index cd584b3c..00000000
--- a/Timeline/Migrations/ProductionDatabase/20191031064541_Initialize.Designer.cs
+++ /dev/null
@@ -1,137 +0,0 @@
-// <auto-generated />

-using System;

-using Microsoft.EntityFrameworkCore;

-using Microsoft.EntityFrameworkCore.Infrastructure;

-using Microsoft.EntityFrameworkCore.Migrations;

-using Microsoft.EntityFrameworkCore.Storage.ValueConversion;

-using Timeline.Entities;

-

-namespace Timeline.Migrations.ProductionDatabase

-{

-    [DbContext(typeof(ProductionDatabaseContext))]

-    [Migration("20191031064541_Initialize")]

-    partial class Initialize

-    {

-        protected override void BuildTargetModel(ModelBuilder modelBuilder)

-        {

-#pragma warning disable 612, 618

-            modelBuilder

-                .HasAnnotation("ProductVersion", "3.0.0")

-                .HasAnnotation("Relational:MaxIdentifierLength", 64);

-

-            modelBuilder.Entity("Timeline.Entities.User", b =>

-                {

-                    b.Property<long>("Id")

-                        .ValueGeneratedOnAdd()

-                        .HasColumnName("id")

-                        .HasColumnType("bigint");

-

-                    b.Property<string>("EncryptedPassword")

-                        .IsRequired()

-                        .HasColumnName("password")

-                        .HasColumnType("longtext");

-

-                    b.Property<string>("Name")

-                        .IsRequired()

-                        .HasColumnName("name")

-                        .HasColumnType("varchar(26)")

-                        .HasMaxLength(26);

-

-                    b.Property<string>("RoleString")

-                        .IsRequired()

-                        .HasColumnName("roles")

-                        .HasColumnType("longtext");

-

-                    b.Property<long>("Version")

-                        .ValueGeneratedOnAdd()

-                        .HasColumnName("version")

-                        .HasColumnType("bigint")

-                        .HasDefaultValue(0L);

-

-                    b.HasKey("Id");

-

-                    b.HasIndex("Name")

-                        .IsUnique();

-

-                    b.ToTable("users");

-                });

-

-            modelBuilder.Entity("Timeline.Entities.UserAvatar", b =>

-                {

-                    b.Property<long>("Id")

-                        .ValueGeneratedOnAdd()

-                        .HasColumnName("id")

-                        .HasColumnType("bigint");

-

-                    b.Property<byte[]>("Data")

-                        .HasColumnName("data")

-                        .HasColumnType("longblob");

-

-                    b.Property<string>("ETag")

-                        .HasColumnName("etag")

-                        .HasColumnType("varchar(30)")

-                        .HasMaxLength(30);

-

-                    b.Property<DateTime>("LastModified")

-                        .HasColumnName("last_modified")

-                        .HasColumnType("datetime(6)");

-

-                    b.Property<string>("Type")

-                        .HasColumnName("type")

-                        .HasColumnType("longtext");

-

-                    b.Property<long>("UserId")

-                        .HasColumnType("bigint");

-

-                    b.HasKey("Id");

-

-                    b.HasIndex("UserId")

-                        .IsUnique();

-

-                    b.ToTable("user_avatars");

-                });

-

-            modelBuilder.Entity("Timeline.Entities.UserDetail", b =>

-                {

-                    b.Property<long>("Id")

-                        .ValueGeneratedOnAdd()

-                        .HasColumnName("id")

-                        .HasColumnType("bigint");

-

-                    b.Property<string>("Nickname")

-                        .HasColumnName("nickname")

-                        .HasColumnType("varchar(26)")

-                        .HasMaxLength(26);

-

-                    b.Property<long>("UserId")

-                        .HasColumnType("bigint");

-

-                    b.HasKey("Id");

-

-                    b.HasIndex("UserId")

-                        .IsUnique();

-

-                    b.ToTable("user_details");

-                });

-

-            modelBuilder.Entity("Timeline.Entities.UserAvatar", b =>

-                {

-                    b.HasOne("Timeline.Entities.User", null)

-                        .WithOne("Avatar")

-                        .HasForeignKey("Timeline.Entities.UserAvatar", "UserId")

-                        .OnDelete(DeleteBehavior.Cascade)

-                        .IsRequired();

-                });

-

-            modelBuilder.Entity("Timeline.Entities.UserDetail", b =>

-                {

-                    b.HasOne("Timeline.Entities.User", null)

-                        .WithOne("Detail")

-                        .HasForeignKey("Timeline.Entities.UserDetail", "UserId")

-                        .OnDelete(DeleteBehavior.Cascade)

-                        .IsRequired();

-                });

-#pragma warning restore 612, 618

-        }

-    }

-}

diff --git a/Timeline/Migrations/ProductionDatabase/20191031064541_Initialize.cs b/Timeline/Migrations/ProductionDatabase/20191031064541_Initialize.cs
deleted file mode 100644
index dc989a96..00000000
--- a/Timeline/Migrations/ProductionDatabase/20191031064541_Initialize.cs
+++ /dev/null
@@ -1,105 +0,0 @@
-using System;

-using Microsoft.EntityFrameworkCore.Metadata;

-using Microsoft.EntityFrameworkCore.Migrations;

-

-namespace Timeline.Migrations.ProductionDatabase

-{

-    public partial class Initialize : Migration

-    {

-        protected override void Up(MigrationBuilder migrationBuilder)

-        {

-            migrationBuilder.CreateTable(

-                name: "users",

-                columns: table => new

-                {

-                    id = table.Column<long>(nullable: false)

-                        .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),

-                    name = table.Column<string>(maxLength: 26, nullable: false),

-                    password = table.Column<string>(nullable: false),

-                    roles = table.Column<string>(nullable: false),

-                    version = table.Column<long>(nullable: false, defaultValue: 0L)

-                },

-                constraints: table =>

-                {

-                    table.PrimaryKey("PK_users", x => x.id);

-                });

-

-            migrationBuilder.CreateTable(

-                name: "user_avatars",

-                columns: table => new

-                {

-                    id = table.Column<long>(nullable: false)

-                        .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),

-                    data = table.Column<byte[]>(nullable: true),

-                    type = table.Column<string>(nullable: true),

-                    etag = table.Column<string>(maxLength: 30, nullable: true),

-                    last_modified = table.Column<DateTime>(nullable: false),

-                    UserId = table.Column<long>(nullable: false)

-                },

-                constraints: table =>

-                {

-                    table.PrimaryKey("PK_user_avatars", x => x.id);

-                    table.ForeignKey(

-                        name: "FK_user_avatars_users_UserId",

-                        column: x => x.UserId,

-                        principalTable: "users",

-                        principalColumn: "id",

-                        onDelete: ReferentialAction.Cascade);

-                });

-

-            migrationBuilder.CreateTable(

-                name: "user_details",

-                columns: table => new

-                {

-                    id = table.Column<long>(nullable: false)

-                        .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),

-                    nickname = table.Column<string>(maxLength: 26, nullable: true),

-                    UserId = table.Column<long>(nullable: false)

-                },

-                constraints: table =>

-                {

-                    table.PrimaryKey("PK_user_details", x => x.id);

-                    table.ForeignKey(

-                        name: "FK_user_details_users_UserId",

-                        column: x => x.UserId,

-                        principalTable: "users",

-                        principalColumn: "id",

-                        onDelete: ReferentialAction.Cascade);

-                });

-

-            migrationBuilder.CreateIndex(

-                name: "IX_user_avatars_UserId",

-                table: "user_avatars",

-                column: "UserId",

-                unique: true);

-

-            migrationBuilder.CreateIndex(

-                name: "IX_user_details_UserId",

-                table: "user_details",

-                column: "UserId",

-                unique: true);

-

-            migrationBuilder.CreateIndex(

-                name: "IX_users_name",

-                table: "users",

-                column: "name",

-                unique: true);

-

-            // Add a init user. Username is "administrator". Password is "crupest".

-            migrationBuilder.InsertData("users", new string[] { "name", "password", "roles" },

-                new object[] { "administrator", "AQAAAAEAACcQAAAAENsspZrk8Wo+UuMyg6QuWJsNvRg6gVu4K/TumVod3h9GVLX9zDVuQQds3o7V8QWJ2w==", "user,admin" });

-        }

-

-        protected override void Down(MigrationBuilder migrationBuilder)

-        {

-            migrationBuilder.DropTable(

-                name: "user_avatars");

-

-            migrationBuilder.DropTable(

-                name: "user_details");

-

-            migrationBuilder.DropTable(

-                name: "users");

-        }

-    }

-}

diff --git a/Timeline/Migrations/ProductionDatabase/20191120104512_InitTimeline.Designer.cs b/Timeline/Migrations/ProductionDatabase/20191120104512_InitTimeline.Designer.cs
deleted file mode 100644
index d50e8330..00000000
--- a/Timeline/Migrations/ProductionDatabase/20191120104512_InitTimeline.Designer.cs
+++ /dev/null
@@ -1,270 +0,0 @@
-// <auto-generated />
-using System;
-using Microsoft.EntityFrameworkCore;
-using Microsoft.EntityFrameworkCore.Infrastructure;
-using Microsoft.EntityFrameworkCore.Migrations;
-using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
-using Timeline.Entities;
-
-namespace Timeline.Migrations.ProductionDatabase
-{
-    [DbContext(typeof(ProductionDatabaseContext))]
-    [Migration("20191120104512_InitTimeline")]
-    partial class InitTimeline
-    {
-        protected override void BuildTargetModel(ModelBuilder modelBuilder)
-        {
-#pragma warning disable 612, 618
-            modelBuilder
-                .HasAnnotation("ProductVersion", "3.0.1")
-                .HasAnnotation("Relational:MaxIdentifierLength", 64);
-
-            modelBuilder.Entity("Timeline.Entities.TimelineEntity", b =>
-                {
-                    b.Property<long>("Id")
-                        .ValueGeneratedOnAdd()
-                        .HasColumnName("id")
-                        .HasColumnType("bigint");
-
-                    b.Property<DateTime>("CreateTime")
-                        .HasColumnName("create_time")
-                        .HasColumnType("datetime(6)");
-
-                    b.Property<string>("Description")
-                        .HasColumnName("description")
-                        .HasColumnType("longtext CHARACTER SET utf8mb4");
-
-                    b.Property<string>("Name")
-                        .HasColumnName("name")
-                        .HasColumnType("longtext CHARACTER SET utf8mb4");
-
-                    b.Property<long>("OwnerId")
-                        .HasColumnName("owner")
-                        .HasColumnType("bigint");
-
-                    b.Property<int>("Visibility")
-                        .HasColumnName("visibility")
-                        .HasColumnType("int");
-
-                    b.HasKey("Id");
-
-                    b.HasIndex("OwnerId");
-
-                    b.ToTable("timelines");
-                });
-
-            modelBuilder.Entity("Timeline.Entities.TimelineMemberEntity", b =>
-                {
-                    b.Property<long>("Id")
-                        .ValueGeneratedOnAdd()
-                        .HasColumnName("id")
-                        .HasColumnType("bigint");
-
-                    b.Property<long>("TimelineId")
-                        .HasColumnName("timeline")
-                        .HasColumnType("bigint");
-
-                    b.Property<long>("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<long>("Id")
-                        .ValueGeneratedOnAdd()
-                        .HasColumnName("id")
-                        .HasColumnType("bigint");
-
-                    b.Property<long>("AuthorId")
-                        .HasColumnName("author")
-                        .HasColumnType("bigint");
-
-                    b.Property<string>("Content")
-                        .HasColumnName("content")
-                        .HasColumnType("longtext CHARACTER SET utf8mb4");
-
-                    b.Property<DateTime>("LastUpdated")
-                        .HasColumnName("last_updated")
-                        .HasColumnType("datetime(6)");
-
-                    b.Property<DateTime>("Time")
-                        .HasColumnName("time")
-                        .HasColumnType("datetime(6)");
-
-                    b.Property<long>("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<long>("Id")
-                        .ValueGeneratedOnAdd()
-                        .HasColumnName("id")
-                        .HasColumnType("bigint");
-
-                    b.Property<string>("EncryptedPassword")
-                        .IsRequired()
-                        .HasColumnName("password")
-                        .HasColumnType("longtext CHARACTER SET utf8mb4");
-
-                    b.Property<string>("Name")
-                        .IsRequired()
-                        .HasColumnName("name")
-                        .HasColumnType("varchar(26) CHARACTER SET utf8mb4")
-                        .HasMaxLength(26);
-
-                    b.Property<string>("RoleString")
-                        .IsRequired()
-                        .HasColumnName("roles")
-                        .HasColumnType("longtext CHARACTER SET utf8mb4");
-
-                    b.Property<long>("Version")
-                        .ValueGeneratedOnAdd()
-                        .HasColumnName("version")
-                        .HasColumnType("bigint")
-                        .HasDefaultValue(0L);
-
-                    b.HasKey("Id");
-
-                    b.HasIndex("Name")
-                        .IsUnique();
-
-                    b.ToTable("users");
-                });
-
-            modelBuilder.Entity("Timeline.Entities.UserAvatar", b =>
-                {
-                    b.Property<long>("Id")
-                        .ValueGeneratedOnAdd()
-                        .HasColumnName("id")
-                        .HasColumnType("bigint");
-
-                    b.Property<byte[]>("Data")
-                        .HasColumnName("data")
-                        .HasColumnType("longblob");
-
-                    b.Property<string>("ETag")
-                        .HasColumnName("etag")
-                        .HasColumnType("varchar(30) CHARACTER SET utf8mb4")
-                        .HasMaxLength(30);
-
-                    b.Property<DateTime>("LastModified")
-                        .HasColumnName("last_modified")
-                        .HasColumnType("datetime(6)");
-
-                    b.Property<string>("Type")
-                        .HasColumnName("type")
-                        .HasColumnType("longtext CHARACTER SET utf8mb4");
-
-                    b.Property<long>("UserId")
-                        .HasColumnType("bigint");
-
-                    b.HasKey("Id");
-
-                    b.HasIndex("UserId")
-                        .IsUnique();
-
-                    b.ToTable("user_avatars");
-                });
-
-            modelBuilder.Entity("Timeline.Entities.UserDetail", b =>
-                {
-                    b.Property<long>("Id")
-                        .ValueGeneratedOnAdd()
-                        .HasColumnName("id")
-                        .HasColumnType("bigint");
-
-                    b.Property<string>("Nickname")
-                        .HasColumnName("nickname")
-                        .HasColumnType("varchar(26) CHARACTER SET utf8mb4")
-                        .HasMaxLength(26);
-
-                    b.Property<long>("UserId")
-                        .HasColumnType("bigint");
-
-                    b.HasKey("Id");
-
-                    b.HasIndex("UserId")
-                        .IsUnique();
-
-                    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)
-                        .WithOne("Avatar")
-                        .HasForeignKey("Timeline.Entities.UserAvatar", "UserId")
-                        .OnDelete(DeleteBehavior.Cascade)
-                        .IsRequired();
-                });
-
-            modelBuilder.Entity("Timeline.Entities.UserDetail", b =>
-                {
-                    b.HasOne("Timeline.Entities.User", null)
-                        .WithOne("Detail")
-                        .HasForeignKey("Timeline.Entities.UserDetail", "UserId")
-                        .OnDelete(DeleteBehavior.Cascade)
-                        .IsRequired();
-                });
-#pragma warning restore 612, 618
-        }
-    }
-}
diff --git a/Timeline/Migrations/ProductionDatabase/20191120104512_InitTimeline.cs b/Timeline/Migrations/ProductionDatabase/20191120104512_InitTimeline.cs
deleted file mode 100644
index 9b80ad30..00000000
--- a/Timeline/Migrations/ProductionDatabase/20191120104512_InitTimeline.cs
+++ /dev/null
@@ -1,229 +0,0 @@
-using System;
-using Microsoft.EntityFrameworkCore.Metadata;
-using Microsoft.EntityFrameworkCore.Migrations;
-
-namespace Timeline.Migrations.ProductionDatabase
-{
-    public partial class InitTimeline : Migration
-    {
-        protected override void Up(MigrationBuilder migrationBuilder)
-        {
-            migrationBuilder.AlterColumn<string>(
-                name: "roles",
-                table: "users",
-                nullable: false,
-                oldClrType: typeof(string),
-                oldType: "longtext");
-
-            migrationBuilder.AlterColumn<string>(
-                name: "name",
-                table: "users",
-                maxLength: 26,
-                nullable: false,
-                oldClrType: typeof(string),
-                oldType: "varchar(26)",
-                oldMaxLength: 26);
-
-            migrationBuilder.AlterColumn<string>(
-                name: "password",
-                table: "users",
-                nullable: false,
-                oldClrType: typeof(string),
-                oldType: "longtext");
-
-            migrationBuilder.AlterColumn<string>(
-                name: "nickname",
-                table: "user_details",
-                maxLength: 26,
-                nullable: true,
-                oldClrType: typeof(string),
-                oldType: "varchar(26)",
-                oldMaxLength: 26,
-                oldNullable: true);
-
-            migrationBuilder.AlterColumn<string>(
-                name: "type",
-                table: "user_avatars",
-                nullable: true,
-                oldClrType: typeof(string),
-                oldType: "longtext",
-                oldNullable: true);
-
-            migrationBuilder.AlterColumn<string>(
-                name: "etag",
-                table: "user_avatars",
-                maxLength: 30,
-                nullable: true,
-                oldClrType: typeof(string),
-                oldType: "varchar(30)",
-                oldMaxLength: 30,
-                oldNullable: true);
-
-            migrationBuilder.CreateTable(
-                name: "timelines",
-                columns: table => new
-                {
-                    id = table.Column<long>(nullable: false)
-                        .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
-                    name = table.Column<string>(nullable: true),
-                    description = table.Column<string>(nullable: true),
-                    owner = table.Column<long>(nullable: false),
-                    visibility = table.Column<int>(nullable: false),
-                    create_time = table.Column<DateTime>(nullable: false)
-                },
-                constraints: table =>
-                {
-                    table.PrimaryKey("PK_timelines", x => x.id);
-                    table.ForeignKey(
-                        name: "FK_timelines_users_owner",
-                        column: x => x.owner,
-                        principalTable: "users",
-                        principalColumn: "id",
-                        onDelete: ReferentialAction.Cascade);
-                });
-
-            migrationBuilder.CreateTable(
-                name: "timeline_posts",
-                columns: table => new
-                {
-                    id = table.Column<long>(nullable: false)
-                        .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
-                    timeline = table.Column<long>(nullable: false),
-                    author = table.Column<long>(nullable: false),
-                    content = table.Column<string>(nullable: true),
-                    time = table.Column<DateTime>(nullable: false),
-                    last_updated = table.Column<DateTime>(nullable: false)
-                },
-                constraints: table =>
-                {
-                    table.PrimaryKey("PK_timeline_posts", x => x.id);
-                    table.ForeignKey(
-                        name: "FK_timeline_posts_users_author",
-                        column: x => x.author,
-                        principalTable: "users",
-                        principalColumn: "id",
-                        onDelete: ReferentialAction.Cascade);
-                    table.ForeignKey(
-                        name: "FK_timeline_posts_timelines_timeline",
-                        column: x => x.timeline,
-                        principalTable: "timelines",
-                        principalColumn: "id",
-                        onDelete: ReferentialAction.Cascade);
-                });
-
-            migrationBuilder.CreateTable(
-                name: "TimelineMembers",
-                columns: table => new
-                {
-                    id = table.Column<long>(nullable: false)
-                        .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
-                    user = table.Column<long>(nullable: false),
-                    timeline = table.Column<long>(nullable: false)
-                },
-                constraints: table =>
-                {
-                    table.PrimaryKey("PK_TimelineMembers", x => x.id);
-                    table.ForeignKey(
-                        name: "FK_TimelineMembers_timelines_timeline",
-                        column: x => x.timeline,
-                        principalTable: "timelines",
-                        principalColumn: "id",
-                        onDelete: ReferentialAction.Cascade);
-                    table.ForeignKey(
-                        name: "FK_TimelineMembers_users_user",
-                        column: x => x.user,
-                        principalTable: "users",
-                        principalColumn: "id",
-                        onDelete: ReferentialAction.Cascade);
-                });
-
-            migrationBuilder.CreateIndex(
-                name: "IX_timeline_posts_author",
-                table: "timeline_posts",
-                column: "author");
-
-            migrationBuilder.CreateIndex(
-                name: "IX_timeline_posts_timeline",
-                table: "timeline_posts",
-                column: "timeline");
-
-            migrationBuilder.CreateIndex(
-                name: "IX_TimelineMembers_timeline",
-                table: "TimelineMembers",
-                column: "timeline");
-
-            migrationBuilder.CreateIndex(
-                name: "IX_TimelineMembers_user",
-                table: "TimelineMembers",
-                column: "user");
-
-            migrationBuilder.CreateIndex(
-                name: "IX_timelines_owner",
-                table: "timelines",
-                column: "owner");
-        }
-
-        protected override void Down(MigrationBuilder migrationBuilder)
-        {
-            migrationBuilder.DropTable(
-                name: "timeline_posts");
-
-            migrationBuilder.DropTable(
-                name: "TimelineMembers");
-
-            migrationBuilder.DropTable(
-                name: "timelines");
-
-            migrationBuilder.AlterColumn<string>(
-                name: "roles",
-                table: "users",
-                type: "longtext",
-                nullable: false,
-                oldClrType: typeof(string));
-
-            migrationBuilder.AlterColumn<string>(
-                name: "name",
-                table: "users",
-                type: "varchar(26)",
-                maxLength: 26,
-                nullable: false,
-                oldClrType: typeof(string),
-                oldMaxLength: 26);
-
-            migrationBuilder.AlterColumn<string>(
-                name: "password",
-                table: "users",
-                type: "longtext",
-                nullable: false,
-                oldClrType: typeof(string));
-
-            migrationBuilder.AlterColumn<string>(
-                name: "nickname",
-                table: "user_details",
-                type: "varchar(26)",
-                maxLength: 26,
-                nullable: true,
-                oldClrType: typeof(string),
-                oldMaxLength: 26,
-                oldNullable: true);
-
-            migrationBuilder.AlterColumn<string>(
-                name: "type",
-                table: "user_avatars",
-                type: "longtext",
-                nullable: true,
-                oldClrType: typeof(string),
-                oldNullable: true);
-
-            migrationBuilder.AlterColumn<string>(
-                name: "etag",
-                table: "user_avatars",
-                type: "varchar(30)",
-                maxLength: 30,
-                nullable: true,
-                oldClrType: typeof(string),
-                oldMaxLength: 30,
-                oldNullable: true);
-        }
-    }
-}
diff --git a/Timeline/Migrations/ProductionDatabase/20200105151839_RenameTimelineMember.Designer.cs b/Timeline/Migrations/ProductionDatabase/20200105151839_RenameTimelineMember.Designer.cs
deleted file mode 100644
index 356406fa..00000000
--- a/Timeline/Migrations/ProductionDatabase/20200105151839_RenameTimelineMember.Designer.cs
+++ /dev/null
@@ -1,270 +0,0 @@
-// <auto-generated />

-using System;

-using Microsoft.EntityFrameworkCore;

-using Microsoft.EntityFrameworkCore.Infrastructure;

-using Microsoft.EntityFrameworkCore.Migrations;

-using Microsoft.EntityFrameworkCore.Storage.ValueConversion;

-using Timeline.Entities;

-

-namespace Timeline.Migrations.ProductionDatabase

-{

-    [DbContext(typeof(ProductionDatabaseContext))]

-    [Migration("20200105151839_RenameTimelineMember")]

-    partial class RenameTimelineMember

-    {

-        protected override void BuildTargetModel(ModelBuilder modelBuilder)

-        {

-#pragma warning disable 612, 618

-            modelBuilder

-                .HasAnnotation("ProductVersion", "3.1.0")

-                .HasAnnotation("Relational:MaxIdentifierLength", 64);

-

-            modelBuilder.Entity("Timeline.Entities.TimelineEntity", b =>

-                {

-                    b.Property<long>("Id")

-                        .ValueGeneratedOnAdd()

-                        .HasColumnName("id")

-                        .HasColumnType("bigint");

-

-                    b.Property<DateTime>("CreateTime")

-                        .HasColumnName("create_time")

-                        .HasColumnType("datetime(6)");

-

-                    b.Property<string>("Description")

-                        .HasColumnName("description")

-                        .HasColumnType("longtext CHARACTER SET utf8mb4");

-

-                    b.Property<string>("Name")

-                        .HasColumnName("name")

-                        .HasColumnType("longtext CHARACTER SET utf8mb4");

-

-                    b.Property<long>("OwnerId")

-                        .HasColumnName("owner")

-                        .HasColumnType("bigint");

-

-                    b.Property<int>("Visibility")

-                        .HasColumnName("visibility")

-                        .HasColumnType("int");

-

-                    b.HasKey("Id");

-

-                    b.HasIndex("OwnerId");

-

-                    b.ToTable("timelines");

-                });

-

-            modelBuilder.Entity("Timeline.Entities.TimelineMemberEntity", b =>

-                {

-                    b.Property<long>("Id")

-                        .ValueGeneratedOnAdd()

-                        .HasColumnName("id")

-                        .HasColumnType("bigint");

-

-                    b.Property<long>("TimelineId")

-                        .HasColumnName("timeline")

-                        .HasColumnType("bigint");

-

-                    b.Property<long>("UserId")

-                        .HasColumnName("user")

-                        .HasColumnType("bigint");

-

-                    b.HasKey("Id");

-

-                    b.HasIndex("TimelineId");

-

-                    b.HasIndex("UserId");

-

-                    b.ToTable("timeline_members");

-                });

-

-            modelBuilder.Entity("Timeline.Entities.TimelinePostEntity", b =>

-                {

-                    b.Property<long>("Id")

-                        .ValueGeneratedOnAdd()

-                        .HasColumnName("id")

-                        .HasColumnType("bigint");

-

-                    b.Property<long>("AuthorId")

-                        .HasColumnName("author")

-                        .HasColumnType("bigint");

-

-                    b.Property<string>("Content")

-                        .HasColumnName("content")

-                        .HasColumnType("longtext CHARACTER SET utf8mb4");

-

-                    b.Property<DateTime>("LastUpdated")

-                        .HasColumnName("last_updated")

-                        .HasColumnType("datetime(6)");

-

-                    b.Property<DateTime>("Time")

-                        .HasColumnName("time")

-                        .HasColumnType("datetime(6)");

-

-                    b.Property<long>("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<long>("Id")

-                        .ValueGeneratedOnAdd()

-                        .HasColumnName("id")

-                        .HasColumnType("bigint");

-

-                    b.Property<string>("EncryptedPassword")

-                        .IsRequired()

-                        .HasColumnName("password")

-                        .HasColumnType("longtext CHARACTER SET utf8mb4");

-

-                    b.Property<string>("Name")

-                        .IsRequired()

-                        .HasColumnName("name")

-                        .HasColumnType("varchar(26) CHARACTER SET utf8mb4")

-                        .HasMaxLength(26);

-

-                    b.Property<string>("RoleString")

-                        .IsRequired()

-                        .HasColumnName("roles")

-                        .HasColumnType("longtext CHARACTER SET utf8mb4");

-

-                    b.Property<long>("Version")

-                        .ValueGeneratedOnAdd()

-                        .HasColumnName("version")

-                        .HasColumnType("bigint")

-                        .HasDefaultValue(0L);

-

-                    b.HasKey("Id");

-

-                    b.HasIndex("Name")

-                        .IsUnique();

-

-                    b.ToTable("users");

-                });

-

-            modelBuilder.Entity("Timeline.Entities.UserAvatar", b =>

-                {

-                    b.Property<long>("Id")

-                        .ValueGeneratedOnAdd()

-                        .HasColumnName("id")

-                        .HasColumnType("bigint");

-

-                    b.Property<byte[]>("Data")

-                        .HasColumnName("data")

-                        .HasColumnType("longblob");

-

-                    b.Property<string>("ETag")

-                        .HasColumnName("etag")

-                        .HasColumnType("varchar(30) CHARACTER SET utf8mb4")

-                        .HasMaxLength(30);

-

-                    b.Property<DateTime>("LastModified")

-                        .HasColumnName("last_modified")

-                        .HasColumnType("datetime(6)");

-

-                    b.Property<string>("Type")

-                        .HasColumnName("type")

-                        .HasColumnType("longtext CHARACTER SET utf8mb4");

-

-                    b.Property<long>("UserId")

-                        .HasColumnType("bigint");

-

-                    b.HasKey("Id");

-

-                    b.HasIndex("UserId")

-                        .IsUnique();

-

-                    b.ToTable("user_avatars");

-                });

-

-            modelBuilder.Entity("Timeline.Entities.UserDetail", b =>

-                {

-                    b.Property<long>("Id")

-                        .ValueGeneratedOnAdd()

-                        .HasColumnName("id")

-                        .HasColumnType("bigint");

-

-                    b.Property<string>("Nickname")

-                        .HasColumnName("nickname")

-                        .HasColumnType("varchar(26) CHARACTER SET utf8mb4")

-                        .HasMaxLength(26);

-

-                    b.Property<long>("UserId")

-                        .HasColumnType("bigint");

-

-                    b.HasKey("Id");

-

-                    b.HasIndex("UserId")

-                        .IsUnique();

-

-                    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)

-                        .WithOne("Avatar")

-                        .HasForeignKey("Timeline.Entities.UserAvatar", "UserId")

-                        .OnDelete(DeleteBehavior.Cascade)

-                        .IsRequired();

-                });

-

-            modelBuilder.Entity("Timeline.Entities.UserDetail", b =>

-                {

-                    b.HasOne("Timeline.Entities.User", null)

-                        .WithOne("Detail")

-                        .HasForeignKey("Timeline.Entities.UserDetail", "UserId")

-                        .OnDelete(DeleteBehavior.Cascade)

-                        .IsRequired();

-                });

-#pragma warning restore 612, 618

-        }

-    }

-}

diff --git a/Timeline/Migrations/ProductionDatabase/20200105151839_RenameTimelineMember.cs b/Timeline/Migrations/ProductionDatabase/20200105151839_RenameTimelineMember.cs
deleted file mode 100644
index 8aef42d7..00000000
--- a/Timeline/Migrations/ProductionDatabase/20200105151839_RenameTimelineMember.cs
+++ /dev/null
@@ -1,107 +0,0 @@
-using Microsoft.EntityFrameworkCore.Migrations;

-

-namespace Timeline.Migrations.ProductionDatabase

-{

-    public partial class RenameTimelineMember : Migration

-    {

-        protected override void Up(MigrationBuilder migrationBuilder)

-        {

-            migrationBuilder.DropForeignKey(

-                name: "FK_TimelineMembers_timelines_timeline",

-                table: "TimelineMembers");

-

-            migrationBuilder.DropForeignKey(

-                name: "FK_TimelineMembers_users_user",

-                table: "TimelineMembers");

-

-            migrationBuilder.DropPrimaryKey(

-                name: "PK_TimelineMembers",

-                table: "TimelineMembers");

-

-            migrationBuilder.RenameTable(

-                name: "TimelineMembers",

-                newName: "timeline_members");

-

-            migrationBuilder.RenameIndex(

-                name: "IX_TimelineMembers_user",

-                table: "timeline_members",

-                newName: "IX_timeline_members_user");

-

-            migrationBuilder.RenameIndex(

-                name: "IX_TimelineMembers_timeline",

-                table: "timeline_members",

-                newName: "IX_timeline_members_timeline");

-

-            migrationBuilder.AddPrimaryKey(

-                name: "PK_timeline_members",

-                table: "timeline_members",

-                column: "id");

-

-            migrationBuilder.AddForeignKey(

-                name: "FK_timeline_members_timelines_timeline",

-                table: "timeline_members",

-                column: "timeline",

-                principalTable: "timelines",

-                principalColumn: "id",

-                onDelete: ReferentialAction.Cascade);

-

-            migrationBuilder.AddForeignKey(

-                name: "FK_timeline_members_users_user",

-                table: "timeline_members",

-                column: "user",

-                principalTable: "users",

-                principalColumn: "id",

-                onDelete: ReferentialAction.Cascade);

-        }

-

-        protected override void Down(MigrationBuilder migrationBuilder)

-        {

-            migrationBuilder.DropForeignKey(

-                name: "FK_timeline_members_timelines_timeline",

-                table: "timeline_members");

-

-            migrationBuilder.DropForeignKey(

-                name: "FK_timeline_members_users_user",

-                table: "timeline_members");

-

-            migrationBuilder.DropPrimaryKey(

-                name: "PK_timeline_members",

-                table: "timeline_members");

-

-            migrationBuilder.RenameTable(

-                name: "timeline_members",

-                newName: "TimelineMembers");

-

-            migrationBuilder.RenameIndex(

-                name: "IX_timeline_members_user",

-                table: "TimelineMembers",

-                newName: "IX_TimelineMembers_user");

-

-            migrationBuilder.RenameIndex(

-                name: "IX_timeline_members_timeline",

-                table: "TimelineMembers",

-                newName: "IX_TimelineMembers_timeline");

-

-            migrationBuilder.AddPrimaryKey(

-                name: "PK_TimelineMembers",

-                table: "TimelineMembers",

-                column: "id");

-

-            migrationBuilder.AddForeignKey(

-                name: "FK_TimelineMembers_timelines_timeline",

-                table: "TimelineMembers",

-                column: "timeline",

-                principalTable: "timelines",

-                principalColumn: "id",

-                onDelete: ReferentialAction.Cascade);

-

-            migrationBuilder.AddForeignKey(

-                name: "FK_TimelineMembers_users_user",

-                table: "TimelineMembers",

-                column: "user",

-                principalTable: "users",

-                principalColumn: "id",

-                onDelete: ReferentialAction.Cascade);

-        }

-    }

-}

diff --git a/Timeline/Migrations/ProductionDatabase/20200131152033_RefactorUser.cs b/Timeline/Migrations/ProductionDatabase/20200131152033_RefactorUser.cs
deleted file mode 100644
index a0ca5212..00000000
--- a/Timeline/Migrations/ProductionDatabase/20200131152033_RefactorUser.cs
+++ /dev/null
@@ -1,55 +0,0 @@
-using Microsoft.EntityFrameworkCore.Metadata;

-using Microsoft.EntityFrameworkCore.Migrations;

-

-namespace Timeline.Migrations.ProductionDatabase

-{

-    public partial class RefactorUser : Migration

-    {

-        protected override void Up(MigrationBuilder migrationBuilder)

-        {

-            migrationBuilder.Sql(@"

-START TRANSACTION;

-

-ALTER TABLE `users`

-    CHANGE COLUMN `name` `username` varchar (26) NOT NULL,

-    RENAME INDEX IX_users_name TO IX_users_username,

-    ADD `nickname` varchar(100) CHARACTER SET utf8mb4 NULL;

-

-UPDATE users 

-    SET nickname = (

-        SELECT nickname

-        FROM user_details

-        WHERE user_details.UserId = users.id

-    );

-

-ALTER TABLE `user_avatars`

-    CHANGE COLUMN `UserId` `user` bigint (20) NOT NULL,

-    RENAME INDEX IX_user_avatars_UserId TO IX_user_avatars_user,

-    DROP FOREIGN KEY FK_user_avatars_users_UserId,

-    ADD CONSTRAINT FK_user_avatars_users_user FOREIGN KEY (`user`) REFERENCES `users` (`id`) ON DELETE CASCADE;

-

-COMMIT;

-            ");

-        }

-

-        protected override void Down(MigrationBuilder migrationBuilder)

-        {

-            migrationBuilder.Sql(@"

-START TRANSACTION;

-

-ALTER TABLE `users`

-    CHANGE COLUMN `username` `name` varchar (26) NOT NULL,

-    RENAME INDEX IX_users_username TO IX_users_name,

-    DROP COLUMN `nickname`;

-

-ALTER TABLE `user_avatars`

-    CHANGE COLUMN `user` `UserId` bigint (20) NOT NULL,

-    RENAME INDEX IX_user_avatars_user TO IX_user_avatars_UserId,

-    DROP FOREIGN KEY FK_user_avatars_users_user,

-    ADD CONSTRAINT FK_user_avatars_users_UserId FOREIGN KEY (`UserId`) REFERENCES `users` (`id`) ON DELETE CASCADE;

-

-COMMIT;

-            ");

-        }

-    }

-}

diff --git a/Timeline/Migrations/ProductionDatabase/ProductionDatabaseContextModelSnapshot.cs b/Timeline/Migrations/ProductionDatabase/ProductionDatabaseContextModelSnapshot.cs
deleted file mode 100644
index bfc9b768..00000000
--- a/Timeline/Migrations/ProductionDatabase/ProductionDatabaseContextModelSnapshot.cs
+++ /dev/null
@@ -1,242 +0,0 @@
-// <auto-generated />

-using System;

-using Microsoft.EntityFrameworkCore;

-using Microsoft.EntityFrameworkCore.Infrastructure;

-using Microsoft.EntityFrameworkCore.Storage.ValueConversion;

-using Timeline.Entities;

-

-namespace Timeline.Migrations.ProductionDatabase

-{

-    [DbContext(typeof(ProductionDatabaseContext))]

-    partial class ProductionDatabaseContextModelSnapshot : ModelSnapshot

-    {

-        protected override void BuildModel(ModelBuilder modelBuilder)

-        {

-#pragma warning disable 612, 618

-            modelBuilder

-                .HasAnnotation("ProductVersion", "3.1.1")

-                .HasAnnotation("Relational:MaxIdentifierLength", 64);

-

-            modelBuilder.Entity("Timeline.Entities.TimelineEntity", b =>

-                {

-                    b.Property<long>("Id")

-                        .ValueGeneratedOnAdd()

-                        .HasColumnName("id")

-                        .HasColumnType("bigint");

-

-                    b.Property<DateTime>("CreateTime")

-                        .HasColumnName("create_time")

-                        .HasColumnType("datetime(6)");

-

-                    b.Property<string>("Description")

-                        .HasColumnName("description")

-                        .HasColumnType("longtext CHARACTER SET utf8mb4");

-

-                    b.Property<string>("Name")

-                        .HasColumnName("name")

-                        .HasColumnType("longtext CHARACTER SET utf8mb4");

-

-                    b.Property<long>("OwnerId")

-                        .HasColumnName("owner")

-                        .HasColumnType("bigint");

-

-                    b.Property<int>("Visibility")

-                        .HasColumnName("visibility")

-                        .HasColumnType("int");

-

-                    b.HasKey("Id");

-

-                    b.HasIndex("OwnerId");

-

-                    b.ToTable("timelines");

-                });

-

-            modelBuilder.Entity("Timeline.Entities.TimelineMemberEntity", b =>

-                {

-                    b.Property<long>("Id")

-                        .ValueGeneratedOnAdd()

-                        .HasColumnName("id")

-                        .HasColumnType("bigint");

-

-                    b.Property<long>("TimelineId")

-                        .HasColumnName("timeline")

-                        .HasColumnType("bigint");

-

-                    b.Property<long>("UserId")

-                        .HasColumnName("user")

-                        .HasColumnType("bigint");

-

-                    b.HasKey("Id");

-

-                    b.HasIndex("TimelineId");

-

-                    b.HasIndex("UserId");

-

-                    b.ToTable("timeline_members");

-                });

-

-            modelBuilder.Entity("Timeline.Entities.TimelinePostEntity", b =>

-                {

-                    b.Property<long>("Id")

-                        .ValueGeneratedOnAdd()

-                        .HasColumnName("id")

-                        .HasColumnType("bigint");

-

-                    b.Property<long>("AuthorId")

-                        .HasColumnName("author")

-                        .HasColumnType("bigint");

-

-                    b.Property<string>("Content")

-                        .HasColumnName("content")

-                        .HasColumnType("longtext CHARACTER SET utf8mb4");

-

-                    b.Property<DateTime>("LastUpdated")

-                        .HasColumnName("last_updated")

-                        .HasColumnType("datetime(6)");

-

-                    b.Property<DateTime>("Time")

-                        .HasColumnName("time")

-                        .HasColumnType("datetime(6)");

-

-                    b.Property<long>("TimelineId")

-                        .HasColumnName("timeline")

-                        .HasColumnType("bigint");

-

-                    b.HasKey("Id");

-

-                    b.HasIndex("AuthorId");

-

-                    b.HasIndex("TimelineId");

-

-                    b.ToTable("timeline_posts");

-                });

-

-            modelBuilder.Entity("Timeline.Entities.UserAvatarEntity", b =>

-                {

-                    b.Property<long>("Id")

-                        .ValueGeneratedOnAdd()

-                        .HasColumnName("id")

-                        .HasColumnType("bigint");

-

-                    b.Property<byte[]>("Data")

-                        .HasColumnName("data")

-                        .HasColumnType("longblob");

-

-                    b.Property<string>("ETag")

-                        .HasColumnName("etag")

-                        .HasColumnType("varchar(30) CHARACTER SET utf8mb4")

-                        .HasMaxLength(30);

-

-                    b.Property<DateTime>("LastModified")

-                        .HasColumnName("last_modified")

-                        .HasColumnType("datetime(6)");

-

-                    b.Property<string>("Type")

-                        .HasColumnName("type")

-                        .HasColumnType("longtext CHARACTER SET utf8mb4");

-

-                    b.Property<long>("UserId")

-                        .HasColumnName("user")

-                        .HasColumnType("bigint");

-

-                    b.HasKey("Id");

-

-                    b.HasIndex("UserId")

-                        .IsUnique();

-

-                    b.ToTable("user_avatars");

-                });

-

-            modelBuilder.Entity("Timeline.Entities.UserEntity", b =>

-                {

-                    b.Property<long>("Id")

-                        .ValueGeneratedOnAdd()

-                        .HasColumnName("id")

-                        .HasColumnType("bigint");

-

-                    b.Property<string>("Nickname")

-                        .HasColumnName("nickname")

-                        .HasColumnType("varchar(100) CHARACTER SET utf8mb4")

-                        .HasMaxLength(100);

-

-                    b.Property<string>("Password")

-                        .IsRequired()

-                        .HasColumnName("password")

-                        .HasColumnType("longtext CHARACTER SET utf8mb4");

-

-                    b.Property<string>("Roles")

-                        .IsRequired()

-                        .HasColumnName("roles")

-                        .HasColumnType("longtext CHARACTER SET utf8mb4");

-

-                    b.Property<string>("Username")

-                        .IsRequired()

-                        .HasColumnName("username")

-                        .HasColumnType("varchar(26) CHARACTER SET utf8mb4")

-                        .HasMaxLength(26);

-

-                    b.Property<long>("Version")

-                        .ValueGeneratedOnAdd()

-                        .HasColumnName("version")

-                        .HasColumnType("bigint")

-                        .HasDefaultValue(0L);

-

-                    b.HasKey("Id");

-

-                    b.HasIndex("Username")

-                        .IsUnique();

-

-                    b.ToTable("users");

-                });

-

-            modelBuilder.Entity("Timeline.Entities.TimelineEntity", b =>

-                {

-                    b.HasOne("Timeline.Entities.UserEntity", "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.UserEntity", "User")

-                        .WithMany("TimelinesJoined")

-                        .HasForeignKey("UserId")

-                        .OnDelete(DeleteBehavior.Cascade)

-                        .IsRequired();

-                });

-

-            modelBuilder.Entity("Timeline.Entities.TimelinePostEntity", b =>

-                {

-                    b.HasOne("Timeline.Entities.UserEntity", "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.UserAvatarEntity", b =>

-                {

-                    b.HasOne("Timeline.Entities.UserEntity", "User")

-                        .WithOne("Avatar")

-                        .HasForeignKey("Timeline.Entities.UserAvatarEntity", "UserId")

-                        .OnDelete(DeleteBehavior.Cascade)

-                        .IsRequired();

-                });

-#pragma warning restore 612, 618

-        }

-    }

-}