From 3fa9899e17df4b1012e8b645915ac15022b84f9b Mon Sep 17 00:00:00 2001
From: crupest <crupest@outlook.com>
Date: Fri, 21 Feb 2020 11:59:58 +0800
Subject: Migrate to use sqlite.

---
 .../20200131100517_RefactorUser.cs                 | 129 ---------------------
 1 file changed, 129 deletions(-)
 delete mode 100644 Timeline/Migrations/DevelopmentDatabase/20200131100517_RefactorUser.cs

(limited to 'Timeline/Migrations/DevelopmentDatabase/20200131100517_RefactorUser.cs')

diff --git a/Timeline/Migrations/DevelopmentDatabase/20200131100517_RefactorUser.cs b/Timeline/Migrations/DevelopmentDatabase/20200131100517_RefactorUser.cs
deleted file mode 100644
index ade65eb1..00000000
--- a/Timeline/Migrations/DevelopmentDatabase/20200131100517_RefactorUser.cs
+++ /dev/null
@@ -1,129 +0,0 @@
-using Microsoft.EntityFrameworkCore.Migrations;
-
-namespace Timeline.Migrations.DevelopmentDatabase
-{
-    public partial class RefactorUser : Migration
-    {
-        protected override void Up(MigrationBuilder migrationBuilder)
-        {
-            migrationBuilder.RenameColumn(name: "name", table: "users", newName: "username");
-            migrationBuilder.RenameIndex(name: "IX_users_name", table: "users", newName: "IX_users_username");
-
-            migrationBuilder.AddColumn<string>(
-                name: "nickname",
-                table: "users",
-                maxLength: 100,
-                nullable: true);
-
-            migrationBuilder.Sql(@"
-UPDATE users 
-    SET nickname = (
-        SELECT nickname
-        FROM user_details
-        WHERE user_details.UserId = users.id
-    );
-            ");
-
-            /*
-            migrationBuilder.RenameColumn(name: "UserId", table: "user_avatars", newName: "user");
-
-            migrationBuilder.DropForeignKey(
-                name: "FK_user_avatars_users_UserId",
-                table: "user_avatars");
-
-            migrationBuilder.AddForeignKey(
-                name: "FK_user_avatars_users_user",
-                table: "user_avatars",
-                column: "user",
-                principalTable: "users",
-                principalColumn: "id",
-                onDelete: ReferentialAction.Cascade);
-
-             migrationBuilder.RenameIndex(
-                name: "IX_user_avatars_UserId",
-                table: "user_avatars",
-                newName: "IX_user_avatars_user");
-             */
-
-            migrationBuilder.Sql(@"
-CREATE TABLE user_avatars_backup (
-    id            INTEGER NOT NULL
-                          CONSTRAINT PK_user_avatars PRIMARY KEY AUTOINCREMENT,
-    data          BLOB,
-    type          TEXT,
-    etag          TEXT,
-    last_modified TEXT    NOT NULL,
-    user          INTEGER NOT NULL,
-    CONSTRAINT FK_user_avatars_users_user FOREIGN KEY (
-        user
-    )
-    REFERENCES users (id) ON DELETE CASCADE
-);
-
-INSERT INTO user_avatars_backup (id, data, type, etag, last_modified, user)
-    SELECT id, data, type, etag, last_modified, UserId FROM user_avatars;
-
-DROP TABLE user_avatars;
-
-ALTER TABLE user_avatars_backup
-    RENAME TO user_avatars;
-
-CREATE UNIQUE INDEX IX_user_avatars_user ON user_avatars (user);
-            ");
-
-            // migrationBuilder.DropTable(name: "user_details");
-
-        }
-
-        protected override void Down(MigrationBuilder migrationBuilder)
-        {
-            migrationBuilder.Sql(@"
-CREATE TABLE user_avatars_backup (
-    id            INTEGER NOT NULL
-                          CONSTRAINT PK_user_avatars PRIMARY KEY AUTOINCREMENT,
-    data          BLOB,
-    type          TEXT,
-    etag          TEXT,
-    last_modified TEXT    NOT NULL,
-    UserId        INTEGER NOT NULL,
-    CONSTRAINT FK_user_avatars_users_UserId FOREIGN KEY (
-        user
-    )
-    REFERENCES users (id) ON DELETE CASCADE
-);
-
-INSERT INTO user_avatars_backup (id, data, type, etag, last_modified, UserId)
-    SELECT id, data, type, etag, last_modified, user FROM user_avatars;
-
-DROP TABLE user_avatars;
-
-ALTER TABLE user_avatars_backup
-    RENAME TO user_avatars;
-
-CREATE UNIQUE INDEX IX_user_avatars_UserId ON user_avatars (UserId);
-            ");
-
-            migrationBuilder.Sql(@"
-CREATE TABLE users_backup (
-    id       INTEGER NOT NULL
-                     CONSTRAINT PK_users PRIMARY KEY AUTOINCREMENT,
-    name     TEXT    NOT NULL,
-    password TEXT    NOT NULL,
-    roles    TEXT    NOT NULL,
-    version  INTEGER NOT NULL
-                     DEFAULT 0
-);
-
-INSERT INTO users_backup (id, name, password, roles, version)
-    SELECT id, username, password, roles, version FROM users;
-
-DROP TABLE users;
-
-ALTER TABLE users_backup
-    RENAME TO users;
-
-CREATE UNIQUE INDEX IX_users_name ON users (name);
-            ");
-        }
-    }
-}
-- 
cgit v1.2.3