DW5S/DW5S.Repostory/Migrations/20250307082209_addADCard.cs

using System;
using Microsoft.EntityFrameworkCore.Migrations;

#nullable disable

namespace DW5S.Repostory.Migrations
{
    /// <inheritdoc />
    public partial class addADCard : Migration
    {
        /// <inheritdoc />
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.CreateTable(
                name: "ADCARD",
                columns: table => new
                {
                    ID = table.Column<int>(type: "NUMBER(10)", nullable: false)
                        .Annotation("Oracle:Identity", "START WITH 1 INCREMENT BY 1"),
                    NAME = table.Column<string>(type: "NVARCHAR2(2000)", nullable: true),
                    ADDRESS = table.Column<string>(type: "NVARCHAR2(2000)", nullable: true),
                    TRIGGERMODE = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    CLOCKERTYPE = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    CLOCKFREQ = table.Column<double>(type: "BINARY_DOUBLE", nullable: false),
                    DDCFREQ = table.Column<double>(type: "BINARY_DOUBLE", nullable: false),
                    MUTIL = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    STOREPATH = table.Column<string>(type: "NVARCHAR2(2000)", nullable: true),
                    ENABLE = table.Column<bool>(type: "NUMBER(1)", nullable: false),
                    SERVERSTATUS = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    CREATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false),
                    UPDATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_ADCARD", x => x.ID);
                });

            migrationBuilder.CreateTable(
                name: "ADCHANNEL",
                columns: table => new
                {
                    ID = table.Column<int>(type: "NUMBER(10)", nullable: false)
                        .Annotation("Oracle:Identity", "START WITH 1 INCREMENT BY 1"),
                    ADCARDID = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    CHNUM = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    CENTERFREQ = table.Column<double>(type: "BINARY_DOUBLE", nullable: false),
                    SATINFOID = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    TXINFOID = table.Column<int>(type: "NUMBER(10)", nullable: false),
                    ENABLE = table.Column<bool>(type: "NUMBER(1)", nullable: false),
                    CREATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false),
                    UPDATETIME = table.Column<DateTime>(type: "TIMESTAMP(7)", nullable: false)
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_ADCHANNEL", x => x.ID);
                    table.ForeignKey(
                        name: "FK_ADCHANNEL_ADCARD_ADCARDID",
                        column: x => x.ADCARDID,
                        principalTable: "ADCARD",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_ADCHANNEL_SATINFO_SATINFOID",
                        column: x => x.SATINFOID,
                        principalTable: "SATINFO",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                    table.ForeignKey(
                        name: "FK_ADCHANNEL_TXINFO_TXINFOID",
                        column: x => x.TXINFOID,
                        principalTable: "TXINFO",
                        principalColumn: "ID",
                        onDelete: ReferentialAction.Cascade);
                });

            migrationBuilder.CreateIndex(
                name: "IX_ADCARD_UPDATETIME",
                table: "ADCARD",
                column: "UPDATETIME");

            migrationBuilder.CreateIndex(
                name: "IX_ADCHANNEL_ADCARDID",
                table: "ADCHANNEL",
                column: "ADCARDID");

            migrationBuilder.CreateIndex(
                name: "IX_ADCHANNEL_SATINFOID",
                table: "ADCHANNEL",
                column: "SATINFOID");

            migrationBuilder.CreateIndex(
                name: "IX_ADCHANNEL_TXINFOID",
                table: "ADCHANNEL",
                column: "TXINFOID");

            migrationBuilder.CreateIndex(
                name: "IX_ADCHANNEL_UPDATETIME",
                table: "ADCHANNEL",
                column: "UPDATETIME");
        }

        /// <inheritdoc />
        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropTable(
                name: "ADCHANNEL");

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