DEMOMySql/MicroServices/Business/Business.Host/Migrations/20230217031911_removeMysqlNotMap.cs

using Microsoft.EntityFrameworkCore.Migrations;

#nullable disable

namespace Business.Migrations
{
    public partial class removeMysqlNotMap : Migration
    {
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropColumn(
                name: "bang_id",
                table: "srm_pr_main");

            migrationBuilder.DropColumn(
                name: "bang_id",
                table: "srm_po_occupy");

            migrationBuilder.DropColumn(
                name: "bang_id",
                table: "srm_po_main");

            migrationBuilder.DropColumn(
                name: "bang_id",
                table: "srm_po_list");

            migrationBuilder.DropColumn(
                name: "bang_id",
                table: "mes_oorder");

            migrationBuilder.DropColumn(
                name: "bang_id",
                table: "mes_morder");

            migrationBuilder.DropColumn(
                name: "bang_id",
                table: "mes_mooccupy");

            migrationBuilder.DropColumn(
                name: "bang_id",
                table: "mes_moentry");

            migrationBuilder.DropColumn(
                name: "bang_id",
                table: "ic_plan");

            migrationBuilder.DropColumn(
                name: "bang_id",
                table: "ic_item_stock");

            migrationBuilder.DropColumn(
                name: "mongodb_id",
                table: "ic_item_stock");

            migrationBuilder.DropColumn(
                name: "bang_id",
                table: "ic_item_pur");

            migrationBuilder.DropColumn(
                name: "bang_id",
                table: "ic_factory_details");

            migrationBuilder.DropColumn(
                name: "bang_id",
                table: "crm_seorderentry");

            migrationBuilder.DropColumn(
                name: "bang_id",
                table: "crm_seorder");

            migrationBuilder.AlterTable(
                name: "wms_shipnoticelist",
                comment: "发运通知单详情清单",
                oldComment: "发货通知单明细表")
                .Annotation("MySql:CharSet", "utf8mb4")
                .OldAnnotation("MySql:CharSet", "utf8mb4");

            migrationBuilder.AlterTable(
                name: "wms_shipnotice",
                comment: "发运通知单",
                oldComment: "发货通知单")
                .Annotation("MySql:CharSet", "utf8mb4")
                .OldAnnotation("MySql:CharSet", "utf8mb4");

            migrationBuilder.AlterTable(
                name: "wms_prdprogress",
                comment: "进度字典表",
                oldComment: "进度字典")
                .Annotation("MySql:CharSet", "utf8mb4")
                .OldAnnotation("MySql:CharSet", "utf8mb4");

            migrationBuilder.AlterTable(
                name: "sys_measure_unit",
                comment: "计量单位信息表",
                oldComment: "计量单位表")
                .Annotation("MySql:CharSet", "utf8mb4")
                .OldAnnotation("MySql:CharSet", "utf8mb4");

            migrationBuilder.AlterTable(
                name: "srm_supplier",
                comment: "供应商",
                oldComment: "供应商表")
                .Annotation("MySql:CharSet", "utf8mb4")
                .OldAnnotation("MySql:CharSet", "utf8mb4");

            migrationBuilder.AlterTable(
                name: "sim_issue_type",
                comment: "上升时间",
                oldComment: "sim事项类别表")
                .Annotation("MySql:CharSet", "utf8mb4")
                .OldAnnotation("MySql:CharSet", "utf8mb4");

            migrationBuilder.AlterTable(
                name: "mes_workshop",
                comment: "工位表(工作中心)",
                oldComment: "工位表")
                .Annotation("MySql:CharSet", "utf8mb4")
                .OldAnnotation("MySql:CharSet", "utf8mb4");

            migrationBuilder.AlterTable(
                name: "mes_work_calendar",
                comment: "工作日历",
                oldComment: "工作日历表")
                .Annotation("MySql:CharSet", "utf8mb4")
                .OldAnnotation("MySql:CharSet", "utf8mb4");

            migrationBuilder.AlterTable(
                name: "mes_tech_proc_workshop_icitem",
                comment: "发料到工序表",
                oldComment: "发料到工位表")
                .Annotation("MySql:CharSet", "utf8mb4")
                .OldAnnotation("MySql:CharSet", "utf8mb4");

            migrationBuilder.AlterTable(
                name: "mes_tech_proc_workshop_equipment",
                comment: "工序关联设备表",
                oldComment: "工艺路径关联设备表")
                .Annotation("MySql:CharSet", "utf8mb4")
                .OldAnnotation("MySql:CharSet", "utf8mb4");

            migrationBuilder.AlterTable(
                name: "mes_mereport",
                comment: "生产报工记录表",
                oldComment: "生产报工记录")
                .Annotation("MySql:CharSet", "utf8mb4")
                .OldAnnotation("MySql:CharSet", "utf8mb4");

            migrationBuilder.AlterTable(
                name: "mes_merecheck",
                comment: "生产报检记录表",
                oldComment: "生产报检记录")
                .Annotation("MySql:CharSet", "utf8mb4")
                .OldAnnotation("MySql:CharSet", "utf8mb4");

            migrationBuilder.AlterTable(
                name: "ic_item_inventory",
                comment: "物料库存明细表",
                oldComment: "物料库存信息表")
                .Annotation("MySql:CharSet", "utf8mb4")
                .OldAnnotation("MySql:CharSet", "utf8mb4");

            migrationBuilder.AlterTable(
                name: "crm_seorder",
                comment: "销售订单表",
                oldComment: "销售订单")
                .Annotation("MySql:CharSet", "utf8mb4")
                .OldAnnotation("MySql:CharSet", "utf8mb4");

            migrationBuilder.AlterTable(
                name: "crm_customer",
                comment: "客户",
                oldComment: "客户表")
                .Annotation("MySql:CharSet", "utf8mb4")
                .OldAnnotation("MySql:CharSet", "utf8mb4");

            migrationBuilder.AddColumn<decimal>(
                name: "lqt",
                table: "mes_tech_process",
                type: "decimal(20,8)",
                precision: 20,
                scale: 8,
                nullable: true,
                comment: "前置等待时间");

            migrationBuilder.AddColumn<string>(
                name: "version",
                table: "ic_bom_child",
                type: "varchar(80)",
                maxLength: 80,
                nullable: true,
                comment: "版本")
                .Annotation("MySql:CharSet", "utf8mb4");
        }

        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropColumn(
                name: "lqt",
                table: "mes_tech_process");

            migrationBuilder.DropColumn(
                name: "version",
                table: "ic_bom_child");

            migrationBuilder.AlterTable(
                name: "wms_shipnoticelist",
                comment: "发货通知单明细表",
                oldComment: "发运通知单详情清单")
                .Annotation("MySql:CharSet", "utf8mb4")
                .OldAnnotation("MySql:CharSet", "utf8mb4");

            migrationBuilder.AlterTable(
                name: "wms_shipnotice",
                comment: "发货通知单",
                oldComment: "发运通知单")
                .Annotation("MySql:CharSet", "utf8mb4")
                .OldAnnotation("MySql:CharSet", "utf8mb4");

            migrationBuilder.AlterTable(
                name: "wms_prdprogress",
                comment: "进度字典",
                oldComment: "进度字典表")
                .Annotation("MySql:CharSet", "utf8mb4")
                .OldAnnotation("MySql:CharSet", "utf8mb4");

            migrationBuilder.AlterTable(
                name: "sys_measure_unit",
                comment: "计量单位表",
                oldComment: "计量单位信息表")
                .Annotation("MySql:CharSet", "utf8mb4")
                .OldAnnotation("MySql:CharSet", "utf8mb4");

            migrationBuilder.AlterTable(
                name: "srm_supplier",
                comment: "供应商表",
                oldComment: "供应商")
                .Annotation("MySql:CharSet", "utf8mb4")
                .OldAnnotation("MySql:CharSet", "utf8mb4");

            migrationBuilder.AlterTable(
                name: "sim_issue_type",
                comment: "sim事项类别表",
                oldComment: "上升时间")
                .Annotation("MySql:CharSet", "utf8mb4")
                .OldAnnotation("MySql:CharSet", "utf8mb4");

            migrationBuilder.AlterTable(
                name: "mes_workshop",
                comment: "工位表",
                oldComment: "工位表(工作中心)")
                .Annotation("MySql:CharSet", "utf8mb4")
                .OldAnnotation("MySql:CharSet", "utf8mb4");

            migrationBuilder.AlterTable(
                name: "mes_work_calendar",
                comment: "工作日历表",
                oldComment: "工作日历")
                .Annotation("MySql:CharSet", "utf8mb4")
                .OldAnnotation("MySql:CharSet", "utf8mb4");

            migrationBuilder.AlterTable(
                name: "mes_tech_proc_workshop_icitem",
                comment: "发料到工位表",
                oldComment: "发料到工序表")
                .Annotation("MySql:CharSet", "utf8mb4")
                .OldAnnotation("MySql:CharSet", "utf8mb4");

            migrationBuilder.AlterTable(
                name: "mes_tech_proc_workshop_equipment",
                comment: "工艺路径关联设备表",
                oldComment: "工序关联设备表")
                .Annotation("MySql:CharSet", "utf8mb4")
                .OldAnnotation("MySql:CharSet", "utf8mb4");

            migrationBuilder.AlterTable(
                name: "mes_mereport",
                comment: "生产报工记录",
                oldComment: "生产报工记录表")
                .Annotation("MySql:CharSet", "utf8mb4")
                .OldAnnotation("MySql:CharSet", "utf8mb4");

            migrationBuilder.AlterTable(
                name: "mes_merecheck",
                comment: "生产报检记录",
                oldComment: "生产报检记录表")
                .Annotation("MySql:CharSet", "utf8mb4")
                .OldAnnotation("MySql:CharSet", "utf8mb4");

            migrationBuilder.AlterTable(
                name: "ic_item_inventory",
                comment: "物料库存信息表",
                oldComment: "物料库存明细表")
                .Annotation("MySql:CharSet", "utf8mb4")
                .OldAnnotation("MySql:CharSet", "utf8mb4");

            migrationBuilder.AlterTable(
                name: "crm_seorder",
                comment: "销售订单",
                oldComment: "销售订单表")
                .Annotation("MySql:CharSet", "utf8mb4")
                .OldAnnotation("MySql:CharSet", "utf8mb4");

            migrationBuilder.AlterTable(
                name: "crm_customer",
                comment: "客户表",
                oldComment: "客户")
                .Annotation("MySql:CharSet", "utf8mb4")
                .OldAnnotation("MySql:CharSet", "utf8mb4");

            migrationBuilder.AddColumn<long>(
                name: "bang_id",
                table: "srm_pr_main",
                type: "bigint",
                nullable: true,
                comment: "计算id");

            migrationBuilder.AddColumn<long>(
                name: "bang_id",
                table: "srm_po_occupy",
                type: "bigint",
                nullable: true,
                comment: "计算id");

            migrationBuilder.AddColumn<long>(
                name: "bang_id",
                table: "srm_po_main",
                type: "bigint",
                nullable: true,
                comment: "计算id");

            migrationBuilder.AddColumn<long>(
                name: "bang_id",
                table: "srm_po_list",
                type: "bigint",
                nullable: true,
                comment: "计算id");

            migrationBuilder.AddColumn<long>(
                name: "bang_id",
                table: "mes_oorder",
                type: "bigint",
                nullable: true,
                comment: "计算id");

            migrationBuilder.AddColumn<long>(
                name: "bang_id",
                table: "mes_morder",
                type: "bigint",
                nullable: true,
                comment: "计算id");

            migrationBuilder.AddColumn<long>(
                name: "bang_id",
                table: "mes_mooccupy",
                type: "bigint",
                nullable: true,
                comment: "计算id");

            migrationBuilder.AddColumn<long>(
                name: "bang_id",
                table: "mes_moentry",
                type: "bigint",
                nullable: true,
                comment: "计算id");

            migrationBuilder.AddColumn<long>(
                name: "bang_id",
                table: "ic_plan",
                type: "bigint",
                nullable: true,
                comment: "计算id");

            migrationBuilder.AddColumn<long>(
                name: "bang_id",
                table: "ic_item_stock",
                type: "bigint",
                nullable: true,
                comment: "计算id");

            migrationBuilder.AddColumn<long>(
                name: "mongodb_id",
                table: "ic_item_stock",
                type: "bigint",
                nullable: true,
                comment: "mongodb主键-用于资源检查快照");

            migrationBuilder.AddColumn<long>(
                name: "bang_id",
                table: "ic_item_pur",
                type: "bigint",
                nullable: true,
                comment: "计算id");

            migrationBuilder.AddColumn<long>(
                name: "bang_id",
                table: "ic_factory_details",
                type: "bigint",
                nullable: true,
                comment: "计算id");

            migrationBuilder.AddColumn<long>(
                name: "bang_id",
                table: "crm_seorderentry",
                type: "bigint",
                nullable: true,
                comment: "计算id");

            migrationBuilder.AddColumn<long>(
                name: "bang_id",
                table: "crm_seorder",
                type: "bigint",
                nullable: true,
                comment: "计算id");
        }
    }
}