From d3f1887ba4a8b4ad822406a7a4fc97dbfea91850 Mon Sep 17 00:00:00 2001 From: sunpengfei <i@angelzzz.com> Date: 星期一, 04 八月 2025 09:09:34 +0800 Subject: [PATCH] feat:菜单开发 --- FlexJobApi.Database.Migrations/Migrations/LogDb/20250801141950_Init.cs | 107 ++++++++++++++++++++++++++--------------------------- 1 files changed, 53 insertions(+), 54 deletions(-) diff --git a/FlexJobApi.Database.Migrations/Migrations/LogDb/20250801013139_Init.cs b/FlexJobApi.Database.Migrations/Migrations/LogDb/20250801141950_Init.cs similarity index 84% rename from FlexJobApi.Database.Migrations/Migrations/LogDb/20250801013139_Init.cs rename to FlexJobApi.Database.Migrations/Migrations/LogDb/20250801141950_Init.cs index f0371be..36421e0 100644 --- a/FlexJobApi.Database.Migrations/Migrations/LogDb/20250801013139_Init.cs +++ b/FlexJobApi.Database.Migrations/Migrations/LogDb/20250801141950_Init.cs @@ -24,11 +24,11 @@ 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), - TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true), - CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true), - UpdateUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true), - IsDeleted = table.Column<bool>(type: "bit", nullable: false) + 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 => { @@ -48,11 +48,11 @@ 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), - TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true), - CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true), - UpdateUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true), - IsDeleted = table.Column<bool>(type: "bit", nullable: false) + 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 => { @@ -71,11 +71,11 @@ 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), - TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true), - CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true), - UpdateUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true), - IsDeleted = table.Column<bool>(type: "bit", nullable: false) + 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 => { @@ -95,17 +95,43 @@ 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), - TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true), - CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true), - UpdateUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true), - IsDeleted = table.Column<bool>(type: "bit", nullable: false) + 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", @@ -120,44 +146,17 @@ 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), - TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true), - CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true), - UpdateUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true), - IsDeleted = table.Column<bool>(type: "bit", nullable: false) + 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: "鐭俊鏃ュ織"); - - migrationBuilder.CreateTable( - name: "WebApiLog", - columns: table => new - { - Id = table.Column<Guid>(type: "uniqueidentifier", nullable: false), - Url = table.Column<string>(type: "nvarchar(max)", nullable: false, comment: "閾炬帴鍦板潃"), - Method = table.Column<string>(type: "nvarchar(6)", maxLength: 6, nullable: false, comment: "璇锋眰鏂瑰紡"), - Headers = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "璇锋眰澶�"), - Request = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "璇锋眰鍙傛暟"), - Callback = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "鍥炶皟鏁版嵁"), - IsSuccess = table.Column<bool>(type: "bit", nullable: false, comment: "鏄惁鎴愬姛"), - ClientIpAddress = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "瀹㈡埛绔疘P鍦板潃"), - 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), - TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true), - CreatedUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true), - UpdateUserInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: true), - IsDeleted = table.Column<bool>(type: "bit", nullable: false) - }, - constraints: table => - { - table.PrimaryKey("PK_WebApiLog", x => x.Id); - }, - comment: "鎺ュ彛鏃ュ織"); } /// <inheritdoc /> @@ -176,10 +175,10 @@ name: "QueueLog"); migrationBuilder.DropTable( - name: "SmsLog"); + name: "ResourceLog"); migrationBuilder.DropTable( - name: "WebApiLog"); + name: "SmsLog"); } } } -- Gitblit v1.9.1