From 05ccb4d8f1bbe3fb64e117136b4a89bcfb0b0b33 Mon Sep 17 00:00:00 2001 From: crupest Date: Tue, 27 Oct 2020 19:21:35 +0800 Subject: Split front and back end. --- .../Migrations/20200810155908_AddTimesToUser.cs | 67 ---------------------- 1 file changed, 67 deletions(-) delete mode 100644 Timeline/Migrations/20200810155908_AddTimesToUser.cs (limited to 'Timeline/Migrations/20200810155908_AddTimesToUser.cs') diff --git a/Timeline/Migrations/20200810155908_AddTimesToUser.cs b/Timeline/Migrations/20200810155908_AddTimesToUser.cs deleted file mode 100644 index 369f85e6..00000000 --- a/Timeline/Migrations/20200810155908_AddTimesToUser.cs +++ /dev/null @@ -1,67 +0,0 @@ -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"); - } - } -} -- cgit v1.2.3