using System;
|
using Microsoft.EntityFrameworkCore.Migrations;
|
|
#nullable disable
|
|
namespace ApiTools.Database.Migrations.Migrations.LogDb
|
{
|
/// <inheritdoc />
|
public partial class Init : Migration
|
{
|
/// <inheritdoc />
|
protected override void Up(MigrationBuilder migrationBuilder)
|
{
|
migrationBuilder.CreateTable(
|
name: "ConsoleLog",
|
columns: table => new
|
{
|
Id = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
|
Access = table.Column<int>(type: "int", nullable: false),
|
Level = table.Column<int>(type: "int", nullable: false),
|
Content = table.Column<string>(type: "nvarchar(max)", nullable: false),
|
StackTrace = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
Url = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
Request = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
Ext = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
ClientIpAddress = table.Column<string>(type: "nvarchar(32)", maxLength: 32, nullable: true),
|
Sort = table.Column<int>(type: "int", nullable: false),
|
TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
|
CreatedUserId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
|
CreatedChannelId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
|
UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
|
UpdatedUserId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
|
IsDeleted = table.Column<bool>(type: "bit", nullable: false)
|
},
|
constraints: table =>
|
{
|
table.PrimaryKey("PK_ConsoleLog", x => x.Id);
|
});
|
|
migrationBuilder.CreateTable(
|
name: "DbAuditLog",
|
columns: table => new
|
{
|
Id = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
|
TableName = table.Column<string>(type: "nvarchar(128)", maxLength: 128, nullable: false),
|
PrimaryKey = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
|
Operate = table.Column<int>(type: "int", nullable: false),
|
OldValues = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
NewValues = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
Sort = table.Column<int>(type: "int", nullable: false),
|
TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
|
CreatedUserId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
|
CreatedChannelId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
|
UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
|
UpdatedUserId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
|
IsDeleted = table.Column<bool>(type: "bit", nullable: false)
|
},
|
constraints: table =>
|
{
|
table.PrimaryKey("PK_DbAuditLog", x => x.Id);
|
});
|
|
migrationBuilder.CreateTable(
|
name: "ExceptionLog",
|
columns: table => new
|
{
|
Id = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
|
Type = table.Column<string>(type: "nvarchar(256)", maxLength: 256, nullable: true),
|
Code = table.Column<string>(type: "nvarchar(32)", maxLength: 32, nullable: true),
|
Message = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
StackTrace = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
Sort = table.Column<int>(type: "int", nullable: false),
|
TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
|
CreatedUserId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
|
CreatedChannelId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
|
UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
|
UpdatedUserId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
|
IsDeleted = table.Column<bool>(type: "bit", nullable: false)
|
},
|
constraints: table =>
|
{
|
table.PrimaryKey("PK_ExceptionLog", x => x.Id);
|
});
|
|
migrationBuilder.CreateTable(
|
name: "QueueLog",
|
columns: table => new
|
{
|
Id = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
|
Access = table.Column<int>(type: "int", nullable: false),
|
EventId = table.Column<string>(type: "nvarchar(128)", maxLength: 128, nullable: false),
|
Data = table.Column<string>(type: "nvarchar(max)", nullable: false),
|
IsConsumOnce = table.Column<bool>(type: "bit", nullable: false),
|
ElapsedMilliseconds = table.Column<long>(type: "bigint", nullable: false),
|
Sort = table.Column<int>(type: "int", nullable: false),
|
TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
|
CreatedUserId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
|
CreatedChannelId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
|
UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
|
UpdatedUserId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
|
IsDeleted = table.Column<bool>(type: "bit", nullable: false)
|
},
|
constraints: table =>
|
{
|
table.PrimaryKey("PK_QueueLog", x => x.Id);
|
});
|
|
migrationBuilder.CreateTable(
|
name: "ResourceLog",
|
columns: table => new
|
{
|
Id = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
|
Method = table.Column<int>(type: "int", nullable: false),
|
Domain = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
Path = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
RequestHeaders = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
Request = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
ResponseHeaders = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
Response = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
IsSuccess = table.Column<bool>(type: "bit", nullable: false),
|
ClientIpAddress = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
RefererUrl = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
ConsoleLogs = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
ElapsedMilliseconds = table.Column<long>(type: "bigint", nullable: false),
|
Sort = table.Column<int>(type: "int", nullable: false),
|
TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
|
CreatedUserId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
|
CreatedChannelId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
|
UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
|
UpdatedUserId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
|
IsDeleted = table.Column<bool>(type: "bit", nullable: false)
|
},
|
constraints: table =>
|
{
|
table.PrimaryKey("PK_ResourceLog", x => x.Id);
|
});
|
|
migrationBuilder.CreateTable(
|
name: "ScheduleJobTriggerTimeline",
|
columns: table => new
|
{
|
Id = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
|
JobId = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
TriggerId = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
NumberOfRuns = table.Column<long>(type: "bigint", nullable: false),
|
LastRunTime = table.Column<DateTime>(type: "datetime2", nullable: true),
|
NextRunTime = table.Column<DateTime>(type: "datetime2", nullable: true),
|
Status = table.Column<long>(type: "bigint", nullable: false),
|
Result = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
ElapsedTime = table.Column<long>(type: "bigint", nullable: false),
|
Mode = table.Column<int>(type: "int", nullable: false),
|
Exception = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
Sort = table.Column<int>(type: "int", nullable: false),
|
TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
|
CreatedUserId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
|
CreatedChannelId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
|
UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
|
UpdatedUserId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
|
IsDeleted = table.Column<bool>(type: "bit", nullable: false)
|
},
|
constraints: table =>
|
{
|
table.PrimaryKey("PK_ScheduleJobTriggerTimeline", x => x.Id);
|
});
|
|
migrationBuilder.CreateTable(
|
name: "ThreeResourceLog",
|
columns: table => new
|
{
|
Id = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
|
Method = table.Column<int>(type: "int", nullable: false),
|
Domain = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
Path = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
RequestHeaders = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
Request = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
ResponseHeaders = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
Response = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
IsSuccess = table.Column<bool>(type: "bit", nullable: false),
|
ClientIpAddress = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
RefererUrl = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
ConsoleLogs = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
ElapsedMilliseconds = table.Column<long>(type: "bigint", nullable: false),
|
Sort = table.Column<int>(type: "int", nullable: false),
|
TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true),
|
CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
|
CreatedUserId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
|
CreatedChannelId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
|
UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
|
UpdatedUserId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
|
IsDeleted = table.Column<bool>(type: "bit", nullable: false)
|
},
|
constraints: table =>
|
{
|
table.PrimaryKey("PK_ThreeResourceLog", x => x.Id);
|
});
|
}
|
|
/// <inheritdoc />
|
protected override void Down(MigrationBuilder migrationBuilder)
|
{
|
migrationBuilder.DropTable(
|
name: "ConsoleLog");
|
|
migrationBuilder.DropTable(
|
name: "DbAuditLog");
|
|
migrationBuilder.DropTable(
|
name: "ExceptionLog");
|
|
migrationBuilder.DropTable(
|
name: "QueueLog");
|
|
migrationBuilder.DropTable(
|
name: "ResourceLog");
|
|
migrationBuilder.DropTable(
|
name: "ScheduleJobTriggerTimeline");
|
|
migrationBuilder.DropTable(
|
name: "ThreeResourceLog");
|
}
|
}
|
}
|
