using System;
using Microsoft.EntityFrameworkCore.Migrations;

#nullable disable

namespace FlexJobApi.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, comment: "通道"),
                    Level = table.Column<int>(type: "int", nullable: false, comment: "级别"),
                    Content = table.Column<string>(type: "nvarchar(max)", nullable: false, comment: "内容"),
                    StackTrace = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "堆栈跟踪"),
                    Url = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "链接地址"),
                    ClientIpAddress = table.Column<string>(type: "nvarchar(32)", maxLength: 32, nullable: true, comment: "客户IP地址"),
                    CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
                    UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
                    Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "创建操作人"),
                    UpdateUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "是否删除")
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_ConsoleLog", x => x.Id);
                },
                comment: "控制台日志");

            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, comment: "表名"),
                    PrimaryKey = table.Column<Guid>(type: "uniqueidentifier", nullable: false, comment: "主键"),
                    Operate = table.Column<int>(type: "int", nullable: false, comment: "操作"),
                    OldValues = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "旧值"),
                    NewValues = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "新值"),
                    CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
                    UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
                    Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "创建操作人"),
                    UpdateUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "是否删除")
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_DbAuditLog", x => x.Id);
                },
                comment: "数据库审计日志");

            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, comment: "类型"),
                    Code = table.Column<string>(type: "nvarchar(32)", maxLength: 32, nullable: true, comment: "代码"),
                    Message = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "消息"),
                    StackTrace = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "堆栈跟踪"),
                    CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
                    UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
                    Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "创建操作人"),
                    UpdateUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "是否删除")
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_ExceptionLog", x => x.Id);
                },
                comment: "异常日志");

            migrationBuilder.CreateTable(
                name: "QueueLog",
                columns: table => new
                {
                    Id = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
                    Access = table.Column<int>(type: "int", nullable: false, comment: "通道"),
                    EventId = table.Column<string>(type: "nvarchar(128)", maxLength: 128, nullable: false, comment: "事件Id"),
                    Data = table.Column<string>(type: "nvarchar(max)", nullable: false, comment: "数据"),
                    IsConsumOnce = table.Column<bool>(type: "bit", nullable: false, comment: "消息是否只消费一次"),
                    ElapsedMilliseconds = table.Column<long>(type: "bigint", nullable: false, comment: "耗时毫秒数"),
                    CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
                    UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
                    Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "创建操作人"),
                    UpdateUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "是否删除")
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_QueueLog", x => x.Id);
                },
                comment: "消息队列日志");

            migrationBuilder.CreateTable(
                name: "ResourceLog",
                columns: table => new
                {
                    Id = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
                    Url = table.Column<string>(type: "nvarchar(max)", nullable: false),
                    Method = table.Column<string>(type: "nvarchar(6)", maxLength: 6, nullable: false),
                    Headers = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Request = table.Column<string>(type: "nvarchar(max)", nullable: true),
                    Callback = 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),
                    ElapsedMilliseconds = table.Column<long>(type: "bigint", nullable: false),
                    CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
                    UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
                    Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "创建操作人"),
                    UpdateUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "是否删除")
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_ResourceLog", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "SmsLog",
                columns: table => new
                {
                    Id = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
                    Access = table.Column<int>(type: "int", nullable: false, comment: "通道"),
                    PhoneNumber = table.Column<string>(type: "nvarchar(11)", maxLength: 11, nullable: false, comment: "手机号码"),
                    TemplateCode = table.Column<string>(type: "nvarchar(128)", maxLength: 128, nullable: false, comment: "模板代码"),
                    TemplateParam = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "模板参数"),
                    Expiry = table.Column<DateTime>(type: "datetime2", nullable: true, comment: "有效期"),
                    IsUsed = table.Column<bool>(type: "bit", nullable: false, comment: "是否使用"),
                    CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
                    UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
                    Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
                    TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "跟踪Id"),
                    CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "创建操作人"),
                    UpdateUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true, comment: "最后更新操作人"),
                    IsDeleted = table.Column<bool>(type: "bit", nullable: false, comment: "是否删除")
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_SmsLog", x => x.Id);
                },
                comment: "短信日志");
        }

        /// <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: "SmsLog");
        }
    }
}