alireza
861a98668e
Added [Auditable] attribute to the Chat entity to enable auditing functionality. Created a new migration (AddAuditableToChat) that adds InsertTime, IsRemoved, and RemoveTime columns to the Chat table, along with the necessary database schema updates to support the auditing behavior.
259 lines
11 KiB
C#
259 lines
11 KiB
C#
using System;
|
|
using Microsoft.EntityFrameworkCore.Migrations;
|
|
|
|
#nullable disable
|
|
|
|
namespace Complex.Infrastructure.Migrations
|
|
{
|
|
public partial class AddAuditableToChat : Migration
|
|
{
|
|
protected override void Up(MigrationBuilder migrationBuilder)
|
|
{
|
|
migrationBuilder.AlterColumn<DateTime>(
|
|
name: "InsertTime",
|
|
table: "UnitStates",
|
|
type: "datetime2",
|
|
nullable: false,
|
|
defaultValue: new DateTime(2026, 6, 11, 19, 41, 56, 680, DateTimeKind.Local).AddTicks(2670),
|
|
oldClrType: typeof(DateTime),
|
|
oldType: "datetime2",
|
|
oldDefaultValue: new DateTime(2026, 6, 9, 2, 28, 45, 626, DateTimeKind.Local).AddTicks(1646));
|
|
|
|
migrationBuilder.AlterColumn<DateTime>(
|
|
name: "InsertTime",
|
|
table: "Units",
|
|
type: "datetime2",
|
|
nullable: false,
|
|
defaultValue: new DateTime(2026, 6, 11, 19, 41, 56, 679, DateTimeKind.Local).AddTicks(9506),
|
|
oldClrType: typeof(DateTime),
|
|
oldType: "datetime2",
|
|
oldDefaultValue: new DateTime(2026, 6, 9, 2, 28, 45, 625, DateTimeKind.Local).AddTicks(7151));
|
|
|
|
migrationBuilder.AlterColumn<DateTime>(
|
|
name: "InsertTime",
|
|
table: "UnitCosts",
|
|
type: "datetime2",
|
|
nullable: false,
|
|
defaultValue: new DateTime(2026, 6, 11, 19, 41, 56, 680, DateTimeKind.Local).AddTicks(1537),
|
|
oldClrType: typeof(DateTime),
|
|
oldType: "datetime2",
|
|
oldDefaultValue: new DateTime(2026, 6, 9, 2, 28, 45, 625, DateTimeKind.Local).AddTicks(9764));
|
|
|
|
migrationBuilder.AlterColumn<DateTime>(
|
|
name: "InsertTime",
|
|
table: "Transactions",
|
|
type: "datetime2",
|
|
nullable: false,
|
|
defaultValue: new DateTime(2026, 6, 11, 19, 41, 56, 679, DateTimeKind.Local).AddTicks(7492),
|
|
oldClrType: typeof(DateTime),
|
|
oldType: "datetime2",
|
|
oldDefaultValue: new DateTime(2026, 6, 9, 2, 28, 45, 625, DateTimeKind.Local).AddTicks(3921));
|
|
|
|
migrationBuilder.AlterColumn<DateTime>(
|
|
name: "InsertTime",
|
|
table: "Persons",
|
|
type: "datetime2",
|
|
nullable: false,
|
|
defaultValue: new DateTime(2026, 6, 11, 19, 41, 56, 679, DateTimeKind.Local).AddTicks(5645),
|
|
oldClrType: typeof(DateTime),
|
|
oldType: "datetime2",
|
|
oldDefaultValue: new DateTime(2026, 6, 9, 2, 28, 45, 625, DateTimeKind.Local).AddTicks(1728));
|
|
|
|
migrationBuilder.AlterColumn<DateTime>(
|
|
name: "InsertTime",
|
|
table: "IncomeCostTitles",
|
|
type: "datetime2",
|
|
nullable: false,
|
|
defaultValue: new DateTime(2026, 6, 11, 19, 41, 56, 679, DateTimeKind.Local).AddTicks(3528),
|
|
oldClrType: typeof(DateTime),
|
|
oldType: "datetime2",
|
|
oldDefaultValue: new DateTime(2026, 6, 9, 2, 28, 45, 624, DateTimeKind.Local).AddTicks(9858));
|
|
|
|
migrationBuilder.AlterColumn<DateTime>(
|
|
name: "InsertTime",
|
|
table: "CostCycles",
|
|
type: "datetime2",
|
|
nullable: false,
|
|
defaultValue: new DateTime(2026, 6, 11, 19, 41, 56, 679, DateTimeKind.Local).AddTicks(1849),
|
|
oldClrType: typeof(DateTime),
|
|
oldType: "datetime2",
|
|
oldDefaultValue: new DateTime(2026, 6, 9, 2, 28, 45, 624, DateTimeKind.Local).AddTicks(7249));
|
|
|
|
migrationBuilder.AlterColumn<DateTime>(
|
|
name: "InsertTime",
|
|
table: "ComplexUnitEvents",
|
|
type: "datetime2",
|
|
nullable: false,
|
|
defaultValue: new DateTime(2026, 6, 11, 19, 41, 56, 679, DateTimeKind.Local).AddTicks(795),
|
|
oldClrType: typeof(DateTime),
|
|
oldType: "datetime2",
|
|
oldDefaultValue: new DateTime(2026, 6, 9, 2, 28, 45, 624, DateTimeKind.Local).AddTicks(5016));
|
|
|
|
migrationBuilder.AlterColumn<DateTime>(
|
|
name: "InsertTime",
|
|
table: "ComplexManagers",
|
|
type: "datetime2",
|
|
nullable: false,
|
|
defaultValue: new DateTime(2026, 6, 11, 19, 41, 56, 678, DateTimeKind.Local).AddTicks(9914),
|
|
oldClrType: typeof(DateTime),
|
|
oldType: "datetime2",
|
|
oldDefaultValue: new DateTime(2026, 6, 9, 2, 28, 45, 624, DateTimeKind.Local).AddTicks(2426));
|
|
|
|
migrationBuilder.AlterColumn<DateTime>(
|
|
name: "InsertTime",
|
|
table: "ComplexEntities",
|
|
type: "datetime2",
|
|
nullable: false,
|
|
defaultValue: new DateTime(2026, 6, 11, 19, 41, 56, 678, DateTimeKind.Local).AddTicks(7208),
|
|
oldClrType: typeof(DateTime),
|
|
oldType: "datetime2",
|
|
oldDefaultValue: new DateTime(2026, 6, 9, 2, 28, 45, 623, DateTimeKind.Local).AddTicks(7632));
|
|
|
|
migrationBuilder.AddColumn<DateTime>(
|
|
name: "InsertTime",
|
|
table: "Chats",
|
|
type: "datetime2",
|
|
nullable: false,
|
|
defaultValue: new DateTime(2026, 6, 11, 19, 41, 56, 678, DateTimeKind.Local).AddTicks(4132));
|
|
|
|
migrationBuilder.AddColumn<bool>(
|
|
name: "IsRemoved",
|
|
table: "Chats",
|
|
type: "bit",
|
|
nullable: false,
|
|
defaultValue: false);
|
|
|
|
migrationBuilder.AddColumn<DateTime>(
|
|
name: "RemoveTime",
|
|
table: "Chats",
|
|
type: "datetime2",
|
|
nullable: true);
|
|
|
|
migrationBuilder.AddColumn<DateTime>(
|
|
name: "UpdateTime",
|
|
table: "Chats",
|
|
type: "datetime2",
|
|
nullable: true);
|
|
}
|
|
|
|
protected override void Down(MigrationBuilder migrationBuilder)
|
|
{
|
|
migrationBuilder.DropColumn(
|
|
name: "InsertTime",
|
|
table: "Chats");
|
|
|
|
migrationBuilder.DropColumn(
|
|
name: "IsRemoved",
|
|
table: "Chats");
|
|
|
|
migrationBuilder.DropColumn(
|
|
name: "RemoveTime",
|
|
table: "Chats");
|
|
|
|
migrationBuilder.DropColumn(
|
|
name: "UpdateTime",
|
|
table: "Chats");
|
|
|
|
migrationBuilder.AlterColumn<DateTime>(
|
|
name: "InsertTime",
|
|
table: "UnitStates",
|
|
type: "datetime2",
|
|
nullable: false,
|
|
defaultValue: new DateTime(2026, 6, 9, 2, 28, 45, 626, DateTimeKind.Local).AddTicks(1646),
|
|
oldClrType: typeof(DateTime),
|
|
oldType: "datetime2",
|
|
oldDefaultValue: new DateTime(2026, 6, 11, 19, 41, 56, 680, DateTimeKind.Local).AddTicks(2670));
|
|
|
|
migrationBuilder.AlterColumn<DateTime>(
|
|
name: "InsertTime",
|
|
table: "Units",
|
|
type: "datetime2",
|
|
nullable: false,
|
|
defaultValue: new DateTime(2026, 6, 9, 2, 28, 45, 625, DateTimeKind.Local).AddTicks(7151),
|
|
oldClrType: typeof(DateTime),
|
|
oldType: "datetime2",
|
|
oldDefaultValue: new DateTime(2026, 6, 11, 19, 41, 56, 679, DateTimeKind.Local).AddTicks(9506));
|
|
|
|
migrationBuilder.AlterColumn<DateTime>(
|
|
name: "InsertTime",
|
|
table: "UnitCosts",
|
|
type: "datetime2",
|
|
nullable: false,
|
|
defaultValue: new DateTime(2026, 6, 9, 2, 28, 45, 625, DateTimeKind.Local).AddTicks(9764),
|
|
oldClrType: typeof(DateTime),
|
|
oldType: "datetime2",
|
|
oldDefaultValue: new DateTime(2026, 6, 11, 19, 41, 56, 680, DateTimeKind.Local).AddTicks(1537));
|
|
|
|
migrationBuilder.AlterColumn<DateTime>(
|
|
name: "InsertTime",
|
|
table: "Transactions",
|
|
type: "datetime2",
|
|
nullable: false,
|
|
defaultValue: new DateTime(2026, 6, 9, 2, 28, 45, 625, DateTimeKind.Local).AddTicks(3921),
|
|
oldClrType: typeof(DateTime),
|
|
oldType: "datetime2",
|
|
oldDefaultValue: new DateTime(2026, 6, 11, 19, 41, 56, 679, DateTimeKind.Local).AddTicks(7492));
|
|
|
|
migrationBuilder.AlterColumn<DateTime>(
|
|
name: "InsertTime",
|
|
table: "Persons",
|
|
type: "datetime2",
|
|
nullable: false,
|
|
defaultValue: new DateTime(2026, 6, 9, 2, 28, 45, 625, DateTimeKind.Local).AddTicks(1728),
|
|
oldClrType: typeof(DateTime),
|
|
oldType: "datetime2",
|
|
oldDefaultValue: new DateTime(2026, 6, 11, 19, 41, 56, 679, DateTimeKind.Local).AddTicks(5645));
|
|
|
|
migrationBuilder.AlterColumn<DateTime>(
|
|
name: "InsertTime",
|
|
table: "IncomeCostTitles",
|
|
type: "datetime2",
|
|
nullable: false,
|
|
defaultValue: new DateTime(2026, 6, 9, 2, 28, 45, 624, DateTimeKind.Local).AddTicks(9858),
|
|
oldClrType: typeof(DateTime),
|
|
oldType: "datetime2",
|
|
oldDefaultValue: new DateTime(2026, 6, 11, 19, 41, 56, 679, DateTimeKind.Local).AddTicks(3528));
|
|
|
|
migrationBuilder.AlterColumn<DateTime>(
|
|
name: "InsertTime",
|
|
table: "CostCycles",
|
|
type: "datetime2",
|
|
nullable: false,
|
|
defaultValue: new DateTime(2026, 6, 9, 2, 28, 45, 624, DateTimeKind.Local).AddTicks(7249),
|
|
oldClrType: typeof(DateTime),
|
|
oldType: "datetime2",
|
|
oldDefaultValue: new DateTime(2026, 6, 11, 19, 41, 56, 679, DateTimeKind.Local).AddTicks(1849));
|
|
|
|
migrationBuilder.AlterColumn<DateTime>(
|
|
name: "InsertTime",
|
|
table: "ComplexUnitEvents",
|
|
type: "datetime2",
|
|
nullable: false,
|
|
defaultValue: new DateTime(2026, 6, 9, 2, 28, 45, 624, DateTimeKind.Local).AddTicks(5016),
|
|
oldClrType: typeof(DateTime),
|
|
oldType: "datetime2",
|
|
oldDefaultValue: new DateTime(2026, 6, 11, 19, 41, 56, 679, DateTimeKind.Local).AddTicks(795));
|
|
|
|
migrationBuilder.AlterColumn<DateTime>(
|
|
name: "InsertTime",
|
|
table: "ComplexManagers",
|
|
type: "datetime2",
|
|
nullable: false,
|
|
defaultValue: new DateTime(2026, 6, 9, 2, 28, 45, 624, DateTimeKind.Local).AddTicks(2426),
|
|
oldClrType: typeof(DateTime),
|
|
oldType: "datetime2",
|
|
oldDefaultValue: new DateTime(2026, 6, 11, 19, 41, 56, 678, DateTimeKind.Local).AddTicks(9914));
|
|
|
|
migrationBuilder.AlterColumn<DateTime>(
|
|
name: "InsertTime",
|
|
table: "ComplexEntities",
|
|
type: "datetime2",
|
|
nullable: false,
|
|
defaultValue: new DateTime(2026, 6, 9, 2, 28, 45, 623, DateTimeKind.Local).AddTicks(7632),
|
|
oldClrType: typeof(DateTime),
|
|
oldType: "datetime2",
|
|
oldDefaultValue: new DateTime(2026, 6, 11, 19, 41, 56, 678, DateTimeKind.Local).AddTicks(7208));
|
|
}
|
|
}
|
|
}
|