94 lines
3.4 KiB
C#
94 lines
3.4 KiB
C#
using System;
|
|
using Microsoft.EntityFrameworkCore.Migrations;
|
|
|
|
#nullable disable
|
|
|
|
#pragma warning disable CA1814 // Prefer jagged arrays over multidimensional
|
|
|
|
namespace TechHelper.Server.Migrations
|
|
{
|
|
/// <inheritdoc />
|
|
public partial class up_assign_data : Migration
|
|
{
|
|
/// <inheritdoc />
|
|
protected override void Up(MigrationBuilder migrationBuilder)
|
|
{
|
|
migrationBuilder.DeleteData(
|
|
table: "AspNetRoles",
|
|
keyColumn: "Id",
|
|
keyValue: new Guid("53307917-63c4-468a-ab05-a03882a69ef8"));
|
|
|
|
migrationBuilder.DeleteData(
|
|
table: "AspNetRoles",
|
|
keyColumn: "Id",
|
|
keyValue: new Guid("789b7819-685f-4a2b-9adf-463f397f24d1"));
|
|
|
|
migrationBuilder.DeleteData(
|
|
table: "AspNetRoles",
|
|
keyColumn: "Id",
|
|
keyValue: new Guid("bbea7915-e27c-4ddc-b06c-1f579fc8104e"));
|
|
|
|
migrationBuilder.AddColumn<byte>(
|
|
name: "ExamType",
|
|
table: "assignments",
|
|
type: "tinyint unsigned",
|
|
nullable: false,
|
|
defaultValue: (byte)0);
|
|
|
|
migrationBuilder.AddColumn<string>(
|
|
name: "Name",
|
|
table: "assignments",
|
|
type: "longtext",
|
|
nullable: false)
|
|
.Annotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.InsertData(
|
|
table: "AspNetRoles",
|
|
columns: new[] { "Id", "ConcurrencyStamp", "Name", "NormalizedName" },
|
|
values: new object[,]
|
|
{
|
|
{ new Guid("0775702a-5db7-4747-94d0-4376fad2b58b"), null, "Teacher", "TEACHER" },
|
|
{ new Guid("37f41430-0cb7-44e5-988b-976200bd602d"), null, "Administrator", "ADMINISTRATOR" },
|
|
{ new Guid("df89b9a0-65ef-42dd-b2cb-e59997a72e70"), null, "Student", "STUDENT" }
|
|
});
|
|
}
|
|
|
|
/// <inheritdoc />
|
|
protected override void Down(MigrationBuilder migrationBuilder)
|
|
{
|
|
migrationBuilder.DeleteData(
|
|
table: "AspNetRoles",
|
|
keyColumn: "Id",
|
|
keyValue: new Guid("0775702a-5db7-4747-94d0-4376fad2b58b"));
|
|
|
|
migrationBuilder.DeleteData(
|
|
table: "AspNetRoles",
|
|
keyColumn: "Id",
|
|
keyValue: new Guid("37f41430-0cb7-44e5-988b-976200bd602d"));
|
|
|
|
migrationBuilder.DeleteData(
|
|
table: "AspNetRoles",
|
|
keyColumn: "Id",
|
|
keyValue: new Guid("df89b9a0-65ef-42dd-b2cb-e59997a72e70"));
|
|
|
|
migrationBuilder.DropColumn(
|
|
name: "ExamType",
|
|
table: "assignments");
|
|
|
|
migrationBuilder.DropColumn(
|
|
name: "Name",
|
|
table: "assignments");
|
|
|
|
migrationBuilder.InsertData(
|
|
table: "AspNetRoles",
|
|
columns: new[] { "Id", "ConcurrencyStamp", "Name", "NormalizedName" },
|
|
values: new object[,]
|
|
{
|
|
{ new Guid("53307917-63c4-468a-ab05-a03882a69ef8"), null, "Teacher", "TEACHER" },
|
|
{ new Guid("789b7819-685f-4a2b-9adf-463f397f24d1"), null, "Administrator", "ADMINISTRATOR" },
|
|
{ new Guid("bbea7915-e27c-4ddc-b06c-1f579fc8104e"), null, "Student", "STUDENT" }
|
|
});
|
|
}
|
|
}
|
|
}
|