aboutsummaryrefslogtreecommitdiff
path: root/Timeline/Migrations/20200808071611_UserAddUniqueId.cs
diff options
context:
space:
mode:
Diffstat (limited to 'Timeline/Migrations/20200808071611_UserAddUniqueId.cs')
-rw-r--r--Timeline/Migrations/20200808071611_UserAddUniqueId.cs55
1 files changed, 0 insertions, 55 deletions
diff --git a/Timeline/Migrations/20200808071611_UserAddUniqueId.cs b/Timeline/Migrations/20200808071611_UserAddUniqueId.cs
deleted file mode 100644
index 651a2b05..00000000
--- a/Timeline/Migrations/20200808071611_UserAddUniqueId.cs
+++ /dev/null
@@ -1,55 +0,0 @@
-using Microsoft.EntityFrameworkCore.Migrations;
-
-namespace Timeline.Migrations
-{
- public partial class UserAddUniqueId : 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
-);
-
-INSERT INTO new_users (id, username, password, roles, version, nickname)
- SELECT 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: "unique_id",
- table: "users");
- }
- }
-}