using System; using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace MTWorkHR.Infrastructure.Migrations { /// public partial class addTeamMeetinglogs : Migration { /// protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.CreateTable( name: "MeetingLogs", columns: table => new { Id = table.Column(type: "bigint", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), Method = table.Column(type: "nvarchar(max)", nullable: false), QueryString = table.Column(type: "nvarchar(max)", nullable: true), Input = table.Column(type: "nvarchar(max)", nullable: true), CreateDate = table.Column(type: "datetime2", nullable: false), CreateUser = table.Column(type: "nvarchar(max)", nullable: false), ServerIP = table.Column(type: "nvarchar(max)", nullable: true), Channel = table.Column(type: "nvarchar(max)", nullable: true), UserIP = table.Column(type: "nvarchar(max)", nullable: true), ServiceResponseTimeInSeconds = table.Column(type: "nvarchar(max)", nullable: false), ErrorCode = table.Column(type: "nvarchar(max)", nullable: false), ErrorDescription = table.Column(type: "nvarchar(max)", nullable: false), InnerException = table.Column(type: "nvarchar(max)", nullable: true), userAgent = table.Column(type: "nvarchar(max)", nullable: true) }, constraints: table => { table.PrimaryKey("PK_MeetingLogs", x => x.Id); }); migrationBuilder.CreateTable( name: "TeamLogs", columns: table => new { Id = table.Column(type: "bigint", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), Method = table.Column(type: "nvarchar(max)", nullable: false), QueryString = table.Column(type: "nvarchar(max)", nullable: true), Input = table.Column(type: "nvarchar(max)", nullable: true), CreateDate = table.Column(type: "datetime2", nullable: false), CreateUser = table.Column(type: "nvarchar(max)", nullable: false), ServerIP = table.Column(type: "nvarchar(max)", nullable: true), Channel = table.Column(type: "nvarchar(max)", nullable: true), UserIP = table.Column(type: "nvarchar(max)", nullable: true), ServiceResponseTimeInSeconds = table.Column(type: "nvarchar(max)", nullable: false), ErrorCode = table.Column(type: "nvarchar(max)", nullable: false), ErrorDescription = table.Column(type: "nvarchar(max)", nullable: false), InnerException = table.Column(type: "nvarchar(max)", nullable: true), userAgent = table.Column(type: "nvarchar(max)", nullable: true) }, constraints: table => { table.PrimaryKey("PK_TeamLogs", x => x.Id); }); } /// protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropTable( name: "MeetingLogs"); migrationBuilder.DropTable( name: "TeamLogs"); } } }