Merge pull request #59 from crupest/dev

Migrate to sqlite.

9 files changed, 0 insertions, 1659 deletions

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.Designer.cs b/Timeline/Migrations/ProductionDatabase/20200131152033_RefactorUser.Designer.cs
deleted file mode 100644
index bb0bb5af..00000000
--- a/Timeline/Migrations/ProductionDatabase/20200131152033_RefactorUser.Designer.cs
+++ /dev/null
@@ -1,244 +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("20200131152033_RefactorUser")]

-    partial class RefactorUser

-    {

-        protected override void BuildTargetModel(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

-        }

-    }

-}

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

-        }

-    }

-}