Use sqlite development database.

7 files changed, 1386 insertions, 0 deletions

diff --git a/Timeline/Migrations/ProductionDatabase/20191031064541_Initialize.Designer.cs b/Timeline/Migrations/ProductionDatabase/20191031064541_Initialize.Designer.cs
new file mode 100644
index 00000000..cd584b3c
--- /dev/null
+++ b/Timeline/Migrations/ProductionDatabase/20191031064541_Initialize.Designer.cs
@@ -0,0 +1,137 @@
+// <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
new file mode 100644
index 00000000..dc989a96
--- /dev/null
+++ b/Timeline/Migrations/ProductionDatabase/20191031064541_Initialize.cs
@@ -0,0 +1,105 @@
+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
new file mode 100644
index 00000000..d50e8330
--- /dev/null
+++ b/Timeline/Migrations/ProductionDatabase/20191120104512_InitTimeline.Designer.cs
@@ -0,0 +1,270 @@
+// <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
new file mode 100644
index 00000000..9b80ad30
--- /dev/null
+++ b/Timeline/Migrations/ProductionDatabase/20191120104512_InitTimeline.cs
@@ -0,0 +1,229 @@
+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
new file mode 100644
index 00000000..356406fa
--- /dev/null
+++ b/Timeline/Migrations/ProductionDatabase/20200105151839_RenameTimelineMember.Designer.cs
@@ -0,0 +1,270 @@
+// <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
new file mode 100644
index 00000000..8aef42d7
--- /dev/null
+++ b/Timeline/Migrations/ProductionDatabase/20200105151839_RenameTimelineMember.cs
@@ -0,0 +1,107 @@
+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/ProductionDatabaseContextModelSnapshot.cs b/Timeline/Migrations/ProductionDatabase/ProductionDatabaseContextModelSnapshot.cs
new file mode 100644
index 00000000..67ef52a4
--- /dev/null
+++ b/Timeline/Migrations/ProductionDatabase/ProductionDatabaseContextModelSnapshot.cs
@@ -0,0 +1,268 @@
+// <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.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

+        }

+    }

+}