1 files changed, 67 insertions, 0 deletions
diff --git a/BackEnd/Timeline/Migrations/20200810155908_AddTimesToUser.cs b/BackEnd/Timeline/Migrations/20200810155908_AddTimesToUser.cs
new file mode 100644
index 00000000..369f85e6
--- /dev/null
+++ b/BackEnd/Timeline/Migrations/20200810155908_AddTimesToUser.cs
@@ -0,0 +1,67 @@
+using System;
+using Microsoft.EntityFrameworkCore.Migrations;
+
+namespace Timeline.Migrations
+{
+    public partial class AddTimesToUser : Migration
+    {
+        protected override void Up(MigrationBuilder migrationBuilder)
+        {
+            migrationBuilder.Sql(
+@"
+PRAGMA foreign_keys=OFF;
+
+BEGIN TRANSACTION;
+
+CREATE TABLE new_users (
+    id       INTEGER NOT NULL
+                     CONSTRAINT PK_users PRIMARY KEY AUTOINCREMENT,
+	unique_id TEXT NOT NULL DEFAULT (lower(hex(randomblob(16)))),
+    username TEXT    NOT NULL,
+    password TEXT    NOT NULL,
+    roles    TEXT    NOT NULL,
+    version  INTEGER NOT NULL
+                     DEFAULT 0,
+    nickname TEXT,
+    create_time TEXT NOT NULL DEFAULT (datetime('now', 'utc')),
+    last_modified TEXT NOT NULL DEFAULT (datetime('now', 'utc')),
+    username_change_time TEXT NOT NULL DEFAULT (datetime('now', 'utc'))
+);
+
+INSERT INTO new_users (id, unique_id, username, password, roles, version, nickname)
+	SELECT id, unique_id, username, password, roles, version, nickname FROM users;
+	
+DROP TABLE users;
+
+ALTER TABLE new_users
+	RENAME TO users; 
+
+CREATE UNIQUE INDEX IX_users_username ON users (
+    username
+);
+
+PRAGMA foreign_key_check;
+
+COMMIT TRANSACTION;
+
+PRAGMA foreign_keys=ON;
+"
+, true);
+        }
+
+        protected override void Down(MigrationBuilder migrationBuilder)
+        {
+            migrationBuilder.DropColumn(
+                name: "create_time",
+                table: "users");
+
+            migrationBuilder.DropColumn(
+                name: "last_modified",
+                table: "users");
+
+            migrationBuilder.DropColumn(
+                name: "username_change_time",
+                table: "users");
+        }
+    }
+}