367 lines
20 KiB
C#
367 lines
20 KiB
C#
using System;
|
|
using Microsoft.EntityFrameworkCore.Migrations;
|
|
|
|
#nullable disable
|
|
|
|
namespace EgwCoreLib.Lux.Data.Migrations
|
|
{
|
|
/// <inheritdoc />
|
|
public partial class AddOrderHist : Migration
|
|
{
|
|
/// <inheritdoc />
|
|
protected override void Up(MigrationBuilder migrationBuilder)
|
|
{
|
|
migrationBuilder.AddColumn<string>(
|
|
name: "RawHistory",
|
|
table: "sales_order",
|
|
type: "longtext",
|
|
nullable: false)
|
|
.Annotation("MySql:CharSet", "utf8mb4");
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "sales_offer",
|
|
keyColumn: "OfferID",
|
|
keyValue: 1,
|
|
columns: new[] { "DueDateProm", "DueDateReq", "Inserted", "Modified", "ValidUntil" },
|
|
values: new object[] { new DateTime(2026, 1, 20, 0, 0, 0, 0, DateTimeKind.Local), new DateTime(2025, 12, 21, 0, 0, 0, 0, DateTimeKind.Local), new DateTime(2025, 11, 21, 12, 38, 49, 304, DateTimeKind.Local).AddTicks(1545), new DateTime(2025, 11, 21, 12, 38, 49, 304, DateTimeKind.Local).AddTicks(1547), new DateTime(2025, 12, 21, 12, 38, 49, 304, DateTimeKind.Local).AddTicks(1542) });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "sales_offer",
|
|
keyColumn: "OfferID",
|
|
keyValue: 2,
|
|
columns: new[] { "DueDateProm", "DueDateReq", "Inserted", "Modified", "ValidUntil" },
|
|
values: new object[] { new DateTime(2026, 1, 20, 0, 0, 0, 0, DateTimeKind.Local), new DateTime(2025, 12, 21, 0, 0, 0, 0, DateTimeKind.Local), new DateTime(2025, 11, 21, 12, 38, 49, 304, DateTimeKind.Local).AddTicks(1565), new DateTime(2025, 11, 21, 12, 38, 49, 304, DateTimeKind.Local).AddTicks(1566), new DateTime(2025, 12, 21, 12, 38, 49, 304, DateTimeKind.Local).AddTicks(1564) });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "sales_offer",
|
|
keyColumn: "OfferID",
|
|
keyValue: 3,
|
|
columns: new[] { "DueDateProm", "DueDateReq", "Inserted", "Modified", "ValidUntil" },
|
|
values: new object[] { new DateTime(2026, 1, 20, 0, 0, 0, 0, DateTimeKind.Local), new DateTime(2025, 12, 21, 0, 0, 0, 0, DateTimeKind.Local), new DateTime(2025, 11, 21, 12, 38, 49, 304, DateTimeKind.Local).AddTicks(1574), new DateTime(2025, 11, 21, 12, 38, 49, 304, DateTimeKind.Local).AddTicks(1576), new DateTime(2025, 12, 21, 12, 38, 49, 304, DateTimeKind.Local).AddTicks(1573) });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "sales_offer",
|
|
keyColumn: "OfferID",
|
|
keyValue: 4,
|
|
columns: new[] { "DueDateProm", "DueDateReq", "Inserted", "Modified", "ValidUntil" },
|
|
values: new object[] { new DateTime(2026, 1, 20, 0, 0, 0, 0, DateTimeKind.Local), new DateTime(2025, 12, 21, 0, 0, 0, 0, DateTimeKind.Local), new DateTime(2025, 11, 21, 12, 38, 49, 304, DateTimeKind.Local).AddTicks(1584), new DateTime(2025, 11, 21, 12, 38, 49, 304, DateTimeKind.Local).AddTicks(1585), new DateTime(2025, 12, 21, 12, 38, 49, 304, DateTimeKind.Local).AddTicks(1582) });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "sales_offer_row",
|
|
keyColumn: "OfferRowID",
|
|
keyValue: 1,
|
|
columns: new[] { "Inserted", "Modified" },
|
|
values: new object[] { new DateTime(2025, 11, 21, 12, 38, 49, 304, DateTimeKind.Local).AddTicks(1727), new DateTime(2025, 11, 21, 12, 38, 49, 304, DateTimeKind.Local).AddTicks(1729) });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "sales_offer_row",
|
|
keyColumn: "OfferRowID",
|
|
keyValue: 2,
|
|
columns: new[] { "Inserted", "Modified" },
|
|
values: new object[] { new DateTime(2025, 11, 21, 12, 38, 49, 304, DateTimeKind.Local).AddTicks(1713), new DateTime(2025, 11, 21, 12, 38, 49, 304, DateTimeKind.Local).AddTicks(1715) });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "sales_offer_row",
|
|
keyColumn: "OfferRowID",
|
|
keyValue: 3,
|
|
columns: new[] { "Inserted", "Modified" },
|
|
values: new object[] { new DateTime(2025, 11, 21, 12, 38, 49, 304, DateTimeKind.Local).AddTicks(1739), new DateTime(2025, 11, 21, 12, 38, 49, 304, DateTimeKind.Local).AddTicks(1741) });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "sales_offer_row",
|
|
keyColumn: "OfferRowID",
|
|
keyValue: 4,
|
|
columns: new[] { "Inserted", "Modified" },
|
|
values: new object[] { new DateTime(2025, 11, 21, 12, 38, 49, 304, DateTimeKind.Local).AddTicks(1751), new DateTime(2025, 11, 21, 12, 38, 49, 304, DateTimeKind.Local).AddTicks(1753) });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "sales_offer_row",
|
|
keyColumn: "OfferRowID",
|
|
keyValue: 5,
|
|
columns: new[] { "Inserted", "Modified" },
|
|
values: new object[] { new DateTime(2025, 11, 21, 12, 38, 49, 304, DateTimeKind.Local).AddTicks(1784), new DateTime(2025, 11, 21, 12, 38, 49, 304, DateTimeKind.Local).AddTicks(1786) });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "sales_offer_row",
|
|
keyColumn: "OfferRowID",
|
|
keyValue: 6,
|
|
columns: new[] { "Inserted", "Modified" },
|
|
values: new object[] { new DateTime(2025, 11, 21, 12, 38, 49, 304, DateTimeKind.Local).AddTicks(1796), new DateTime(2025, 11, 21, 12, 38, 49, 304, DateTimeKind.Local).AddTicks(1798) });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "sales_offer_row",
|
|
keyColumn: "OfferRowID",
|
|
keyValue: 7,
|
|
columns: new[] { "Inserted", "Modified" },
|
|
values: new object[] { new DateTime(2025, 11, 21, 12, 38, 49, 304, DateTimeKind.Local).AddTicks(1826), new DateTime(2025, 11, 21, 12, 38, 49, 304, DateTimeKind.Local).AddTicks(1828) });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "sales_offer_row",
|
|
keyColumn: "OfferRowID",
|
|
keyValue: 8,
|
|
columns: new[] { "Inserted", "Modified" },
|
|
values: new object[] { new DateTime(2025, 11, 21, 12, 38, 49, 304, DateTimeKind.Local).AddTicks(1838), new DateTime(2025, 11, 21, 12, 38, 49, 304, DateTimeKind.Local).AddTicks(1840) });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "sales_offer_row",
|
|
keyColumn: "OfferRowID",
|
|
keyValue: 9,
|
|
columns: new[] { "Inserted", "Modified" },
|
|
values: new object[] { new DateTime(2025, 11, 21, 12, 38, 49, 304, DateTimeKind.Local).AddTicks(1868), new DateTime(2025, 11, 21, 12, 38, 49, 304, DateTimeKind.Local).AddTicks(1870) });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "sales_offer_row",
|
|
keyColumn: "OfferRowID",
|
|
keyValue: 10,
|
|
columns: new[] { "Inserted", "Modified" },
|
|
values: new object[] { new DateTime(2025, 11, 21, 12, 38, 49, 304, DateTimeKind.Local).AddTicks(1881), new DateTime(2025, 11, 21, 12, 38, 49, 304, DateTimeKind.Local).AddTicks(1882) });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "stock_mov",
|
|
keyColumn: "StockMovID",
|
|
keyValue: 1,
|
|
column: "DtCreate",
|
|
value: new DateTime(2025, 11, 21, 12, 38, 49, 300, DateTimeKind.Local).AddTicks(5608));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "stock_mov",
|
|
keyColumn: "StockMovID",
|
|
keyValue: 2,
|
|
column: "DtCreate",
|
|
value: new DateTime(2025, 11, 21, 12, 38, 49, 300, DateTimeKind.Local).AddTicks(5662));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "stock_mov",
|
|
keyColumn: "StockMovID",
|
|
keyValue: 3,
|
|
column: "DtCreate",
|
|
value: new DateTime(2025, 11, 21, 12, 38, 49, 300, DateTimeKind.Local).AddTicks(5666));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "stock_mov",
|
|
keyColumn: "StockMovID",
|
|
keyValue: 4,
|
|
column: "DtCreate",
|
|
value: new DateTime(2025, 11, 21, 12, 38, 49, 300, DateTimeKind.Local).AddTicks(5669));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "stock_mov",
|
|
keyColumn: "StockMovID",
|
|
keyValue: 5,
|
|
column: "DtCreate",
|
|
value: new DateTime(2025, 11, 21, 12, 38, 49, 300, DateTimeKind.Local).AddTicks(5673));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "stock_mov",
|
|
keyColumn: "StockMovID",
|
|
keyValue: 6,
|
|
column: "DtCreate",
|
|
value: new DateTime(2025, 11, 21, 12, 38, 49, 300, DateTimeKind.Local).AddTicks(5676));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "stock_mov",
|
|
keyColumn: "StockMovID",
|
|
keyValue: 7,
|
|
column: "DtCreate",
|
|
value: new DateTime(2025, 11, 21, 12, 38, 49, 300, DateTimeKind.Local).AddTicks(5679));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "stock_mov",
|
|
keyColumn: "StockMovID",
|
|
keyValue: 8,
|
|
column: "DtCreate",
|
|
value: new DateTime(2025, 11, 21, 12, 38, 49, 300, DateTimeKind.Local).AddTicks(5683));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "stock_mov",
|
|
keyColumn: "StockMovID",
|
|
keyValue: 9,
|
|
column: "DtCreate",
|
|
value: new DateTime(2025, 11, 21, 12, 38, 49, 300, DateTimeKind.Local).AddTicks(5686));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "stock_mov",
|
|
keyColumn: "StockMovID",
|
|
keyValue: 10,
|
|
column: "DtCreate",
|
|
value: new DateTime(2025, 11, 21, 12, 38, 49, 300, DateTimeKind.Local).AddTicks(5690));
|
|
}
|
|
|
|
/// <inheritdoc />
|
|
protected override void Down(MigrationBuilder migrationBuilder)
|
|
{
|
|
migrationBuilder.DropColumn(
|
|
name: "RawHistory",
|
|
table: "sales_order");
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "sales_offer",
|
|
keyColumn: "OfferID",
|
|
keyValue: 1,
|
|
columns: new[] { "DueDateProm", "DueDateReq", "Inserted", "Modified", "ValidUntil" },
|
|
values: new object[] { new DateTime(2026, 1, 18, 0, 0, 0, 0, DateTimeKind.Local), new DateTime(2025, 12, 19, 0, 0, 0, 0, DateTimeKind.Local), new DateTime(2025, 11, 19, 18, 41, 5, 887, DateTimeKind.Local).AddTicks(6949), new DateTime(2025, 11, 19, 18, 41, 5, 887, DateTimeKind.Local).AddTicks(6951), new DateTime(2025, 12, 19, 18, 41, 5, 887, DateTimeKind.Local).AddTicks(6946) });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "sales_offer",
|
|
keyColumn: "OfferID",
|
|
keyValue: 2,
|
|
columns: new[] { "DueDateProm", "DueDateReq", "Inserted", "Modified", "ValidUntil" },
|
|
values: new object[] { new DateTime(2026, 1, 18, 0, 0, 0, 0, DateTimeKind.Local), new DateTime(2025, 12, 19, 0, 0, 0, 0, DateTimeKind.Local), new DateTime(2025, 11, 19, 18, 41, 5, 887, DateTimeKind.Local).AddTicks(6964), new DateTime(2025, 11, 19, 18, 41, 5, 887, DateTimeKind.Local).AddTicks(6966), new DateTime(2025, 12, 19, 18, 41, 5, 887, DateTimeKind.Local).AddTicks(6963) });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "sales_offer",
|
|
keyColumn: "OfferID",
|
|
keyValue: 3,
|
|
columns: new[] { "DueDateProm", "DueDateReq", "Inserted", "Modified", "ValidUntil" },
|
|
values: new object[] { new DateTime(2026, 1, 18, 0, 0, 0, 0, DateTimeKind.Local), new DateTime(2025, 12, 19, 0, 0, 0, 0, DateTimeKind.Local), new DateTime(2025, 11, 19, 18, 41, 5, 887, DateTimeKind.Local).AddTicks(6974), new DateTime(2025, 11, 19, 18, 41, 5, 887, DateTimeKind.Local).AddTicks(6975), new DateTime(2025, 12, 19, 18, 41, 5, 887, DateTimeKind.Local).AddTicks(6972) });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "sales_offer",
|
|
keyColumn: "OfferID",
|
|
keyValue: 4,
|
|
columns: new[] { "DueDateProm", "DueDateReq", "Inserted", "Modified", "ValidUntil" },
|
|
values: new object[] { new DateTime(2026, 1, 18, 0, 0, 0, 0, DateTimeKind.Local), new DateTime(2025, 12, 19, 0, 0, 0, 0, DateTimeKind.Local), new DateTime(2025, 11, 19, 18, 41, 5, 887, DateTimeKind.Local).AddTicks(6984), new DateTime(2025, 11, 19, 18, 41, 5, 887, DateTimeKind.Local).AddTicks(6985), new DateTime(2025, 12, 19, 18, 41, 5, 887, DateTimeKind.Local).AddTicks(6982) });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "sales_offer_row",
|
|
keyColumn: "OfferRowID",
|
|
keyValue: 1,
|
|
columns: new[] { "Inserted", "Modified" },
|
|
values: new object[] { new DateTime(2025, 11, 19, 18, 41, 5, 887, DateTimeKind.Local).AddTicks(7144), new DateTime(2025, 11, 19, 18, 41, 5, 887, DateTimeKind.Local).AddTicks(7145) });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "sales_offer_row",
|
|
keyColumn: "OfferRowID",
|
|
keyValue: 2,
|
|
columns: new[] { "Inserted", "Modified" },
|
|
values: new object[] { new DateTime(2025, 11, 19, 18, 41, 5, 887, DateTimeKind.Local).AddTicks(7129), new DateTime(2025, 11, 19, 18, 41, 5, 887, DateTimeKind.Local).AddTicks(7131) });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "sales_offer_row",
|
|
keyColumn: "OfferRowID",
|
|
keyValue: 3,
|
|
columns: new[] { "Inserted", "Modified" },
|
|
values: new object[] { new DateTime(2025, 11, 19, 18, 41, 5, 887, DateTimeKind.Local).AddTicks(7156), new DateTime(2025, 11, 19, 18, 41, 5, 887, DateTimeKind.Local).AddTicks(7158) });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "sales_offer_row",
|
|
keyColumn: "OfferRowID",
|
|
keyValue: 4,
|
|
columns: new[] { "Inserted", "Modified" },
|
|
values: new object[] { new DateTime(2025, 11, 19, 18, 41, 5, 887, DateTimeKind.Local).AddTicks(7169), new DateTime(2025, 11, 19, 18, 41, 5, 887, DateTimeKind.Local).AddTicks(7171) });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "sales_offer_row",
|
|
keyColumn: "OfferRowID",
|
|
keyValue: 5,
|
|
columns: new[] { "Inserted", "Modified" },
|
|
values: new object[] { new DateTime(2025, 11, 19, 18, 41, 5, 887, DateTimeKind.Local).AddTicks(7214), new DateTime(2025, 11, 19, 18, 41, 5, 887, DateTimeKind.Local).AddTicks(7215) });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "sales_offer_row",
|
|
keyColumn: "OfferRowID",
|
|
keyValue: 6,
|
|
columns: new[] { "Inserted", "Modified" },
|
|
values: new object[] { new DateTime(2025, 11, 19, 18, 41, 5, 887, DateTimeKind.Local).AddTicks(7226), new DateTime(2025, 11, 19, 18, 41, 5, 887, DateTimeKind.Local).AddTicks(7228) });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "sales_offer_row",
|
|
keyColumn: "OfferRowID",
|
|
keyValue: 7,
|
|
columns: new[] { "Inserted", "Modified" },
|
|
values: new object[] { new DateTime(2025, 11, 19, 18, 41, 5, 887, DateTimeKind.Local).AddTicks(7257), new DateTime(2025, 11, 19, 18, 41, 5, 887, DateTimeKind.Local).AddTicks(7258) });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "sales_offer_row",
|
|
keyColumn: "OfferRowID",
|
|
keyValue: 8,
|
|
columns: new[] { "Inserted", "Modified" },
|
|
values: new object[] { new DateTime(2025, 11, 19, 18, 41, 5, 887, DateTimeKind.Local).AddTicks(7269), new DateTime(2025, 11, 19, 18, 41, 5, 887, DateTimeKind.Local).AddTicks(7271) });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "sales_offer_row",
|
|
keyColumn: "OfferRowID",
|
|
keyValue: 9,
|
|
columns: new[] { "Inserted", "Modified" },
|
|
values: new object[] { new DateTime(2025, 11, 19, 18, 41, 5, 887, DateTimeKind.Local).AddTicks(7300), new DateTime(2025, 11, 19, 18, 41, 5, 887, DateTimeKind.Local).AddTicks(7301) });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "sales_offer_row",
|
|
keyColumn: "OfferRowID",
|
|
keyValue: 10,
|
|
columns: new[] { "Inserted", "Modified" },
|
|
values: new object[] { new DateTime(2025, 11, 19, 18, 41, 5, 887, DateTimeKind.Local).AddTicks(7312), new DateTime(2025, 11, 19, 18, 41, 5, 887, DateTimeKind.Local).AddTicks(7314) });
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "stock_mov",
|
|
keyColumn: "StockMovID",
|
|
keyValue: 1,
|
|
column: "DtCreate",
|
|
value: new DateTime(2025, 11, 19, 18, 41, 5, 883, DateTimeKind.Local).AddTicks(535));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "stock_mov",
|
|
keyColumn: "StockMovID",
|
|
keyValue: 2,
|
|
column: "DtCreate",
|
|
value: new DateTime(2025, 11, 19, 18, 41, 5, 883, DateTimeKind.Local).AddTicks(608));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "stock_mov",
|
|
keyColumn: "StockMovID",
|
|
keyValue: 3,
|
|
column: "DtCreate",
|
|
value: new DateTime(2025, 11, 19, 18, 41, 5, 883, DateTimeKind.Local).AddTicks(613));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "stock_mov",
|
|
keyColumn: "StockMovID",
|
|
keyValue: 4,
|
|
column: "DtCreate",
|
|
value: new DateTime(2025, 11, 19, 18, 41, 5, 883, DateTimeKind.Local).AddTicks(618));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "stock_mov",
|
|
keyColumn: "StockMovID",
|
|
keyValue: 5,
|
|
column: "DtCreate",
|
|
value: new DateTime(2025, 11, 19, 18, 41, 5, 883, DateTimeKind.Local).AddTicks(622));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "stock_mov",
|
|
keyColumn: "StockMovID",
|
|
keyValue: 6,
|
|
column: "DtCreate",
|
|
value: new DateTime(2025, 11, 19, 18, 41, 5, 883, DateTimeKind.Local).AddTicks(627));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "stock_mov",
|
|
keyColumn: "StockMovID",
|
|
keyValue: 7,
|
|
column: "DtCreate",
|
|
value: new DateTime(2025, 11, 19, 18, 41, 5, 883, DateTimeKind.Local).AddTicks(632));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "stock_mov",
|
|
keyColumn: "StockMovID",
|
|
keyValue: 8,
|
|
column: "DtCreate",
|
|
value: new DateTime(2025, 11, 19, 18, 41, 5, 883, DateTimeKind.Local).AddTicks(637));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "stock_mov",
|
|
keyColumn: "StockMovID",
|
|
keyValue: 9,
|
|
column: "DtCreate",
|
|
value: new DateTime(2025, 11, 19, 18, 41, 5, 883, DateTimeKind.Local).AddTicks(642));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "stock_mov",
|
|
keyColumn: "StockMovID",
|
|
keyValue: 10,
|
|
column: "DtCreate",
|
|
value: new DateTime(2025, 11, 19, 18, 41, 5, 883, DateTimeKind.Local).AddTicks(647));
|
|
}
|
|
}
|
|
}
|