ProductionLineMonitor/ProductionLineMonitor.Web/Migrations/20221024120645_202210242006.cs

using System;
using Microsoft.EntityFrameworkCore.Migrations;

namespace ProductionLineMonitor.Web.Migrations
{
    public partial class _202210242006 : Migration
    {
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.CreateTable(
                name: "Cims",
                columns: table => new
                {
                    Id = table.Column<string>(type: "TEXT", nullable: false),
                    Topic = table.Column<string>(type: "TEXT", nullable: true),
                    Time = table.Column<DateTime>(type: "TEXT", nullable: false),
                    IpAddress = table.Column<string>(type: "TEXT", nullable: true),
                    User = table.Column<string>(type: "TEXT", nullable: true),
                    PLCIsConnected = table.Column<bool>(type: "INTEGER", nullable: false),
                    EAPIsConnected = table.Column<bool>(type: "INTEGER", nullable: false),
                    CreateTime = table.Column<DateTime>(type: "TEXT", nullable: true),
                    UpdateTime = table.Column<DateTime>(type: "TEXT", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Cims", x => x.Id);
                });

            migrationBuilder.CreateTable(
                name: "MachineStatistics",
                columns: table => new
                {
                    Id = table.Column<string>(type: "TEXT", nullable: false),
                    MachineId = table.Column<string>(type: "TEXT", nullable: true),
                    Date = table.Column<DateTime>(type: "TEXT", nullable: false),
                    ModuleType = table.Column<string>(type: "TEXT", nullable: true),
                    TT = table.Column<int>(type: "INTEGER", nullable: true),
                    Capacity = table.Column<int>(type: "INTEGER", nullable: true),
                    Availability = table.Column<double>(type: "REAL", nullable: true),
                    Performance = table.Column<double>(type: "REAL", nullable: true),
                    Quality = table.Column<double>(type: "REAL", nullable: true),
                    OEE = table.Column<double>(type: "REAL", nullable: true),
                    CreateTime = table.Column<DateTime>(type: "TEXT", nullable: true),
                    UpdateTime = table.Column<DateTime>(type: "TEXT", nullable: true)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_MachineStatistics", x => x.Id);
                });
        }

        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropTable(
                name: "Cims");

            migrationBuilder.DropTable(
                name: "MachineStatistics");
        }
    }
}