ANTOOZA-BACKEND/Infrastructure/Persistence/Migrations/20260711162422_AddDataCollectionConfigAndOAuthKeys.cs

using Microsoft.EntityFrameworkCore.Migrations;

#nullable disable

namespace Infrastructure.Migrations.AppDb
{
    /// <inheritdoc />
    public partial class AddDataCollectionConfigAndOAuthKeys : Migration
    {
        /// <inheritdoc />
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.AddColumn<string>(
                name: "DataCollection_DataGoKrServiceKeyEnc",
                table: "Config",
                type: "nvarchar(max)",
                nullable: true,
                comment: "금융위 data.go.kr ServiceKey (암호화)");

            migrationBuilder.AddColumn<string>(
                name: "DataCollection_KoreaEximExchangeKeyEnc",
                table: "Config",
                type: "nvarchar(max)",
                nullable: true,
                comment: "수출입은행 환율(AP01) authkey (암호화)");

            migrationBuilder.AddColumn<string>(
                name: "DataCollection_KoreaEximIntlRateKeyEnc",
                table: "Config",
                type: "nvarchar(max)",
                nullable: true,
                comment: "수출입은행 국제금리(AP03) authkey (암호화)");

            migrationBuilder.AddColumn<string>(
                name: "DataCollection_KoreaEximLoanRateKeyEnc",
                table: "Config",
                type: "nvarchar(max)",
                nullable: true,
                comment: "수출입은행 대출금리(AP02) authkey (암호화)");

            migrationBuilder.AddColumn<bool>(
                name: "DataCollection_KoreaEximMacroSync",
                table: "Config",
                type: "bit",
                nullable: false,
                defaultValue: false,
                comment: "수출입은행 거시·환율 수집");

            migrationBuilder.AddColumn<string>(
                name: "DataCollection_KosisApiKeyEnc",
                table: "Config",
                type: "nvarchar(max)",
                nullable: true,
                comment: "KOSIS apiKey (암호화)");

            migrationBuilder.AddColumn<bool>(
                name: "DataCollection_KosisSync",
                table: "Config",
                type: "bit",
                nullable: false,
                defaultValue: false,
                comment: "KOSIS 거시지표 수집");

            migrationBuilder.AddColumn<string>(
                name: "DataCollection_KrxApiKeyEnc",
                table: "Config",
                type: "nvarchar(max)",
                nullable: true,
                comment: "KRX AUTH_KEY (암호화)");

            migrationBuilder.AddColumn<bool>(
                name: "DataCollection_KrxBondIndexSync",
                table: "Config",
                type: "bit",
                nullable: false,
                defaultValue: false,
                comment: "KRX 채권지수 수집");

            migrationBuilder.AddColumn<bool>(
                name: "DataCollection_KrxBondSync",
                table: "Config",
                type: "bit",
                nullable: false,
                defaultValue: false,
                comment: "KRX 채권 일별매매 수집");

            migrationBuilder.AddColumn<bool>(
                name: "DataCollection_KrxCommoditySync",
                table: "Config",
                type: "bit",
                nullable: false,
                defaultValue: false,
                comment: "KRX 일반상품 수집");

            migrationBuilder.AddColumn<bool>(
                name: "DataCollection_KrxDerivativeSync",
                table: "Config",
                type: "bit",
                nullable: false,
                defaultValue: false,
                comment: "KRX 파생상품 수집");

            migrationBuilder.AddColumn<bool>(
                name: "DataCollection_KrxEsgSync",
                table: "Config",
                type: "bit",
                nullable: false,
                defaultValue: false,
                comment: "KRX ESG 수집");

            migrationBuilder.AddColumn<bool>(
                name: "DataCollection_KrxEtpSync",
                table: "Config",
                type: "bit",
                nullable: false,
                defaultValue: false,
                comment: "KRX 증권상품(ETF/ETN/ELW) 수집");

            migrationBuilder.AddColumn<bool>(
                name: "DataCollection_KrxIndexSync",
                table: "Config",
                type: "bit",
                nullable: false,
                defaultValue: false,
                comment: "KRX 지수 수집");

            migrationBuilder.AddColumn<bool>(
                name: "DataCollection_KrxStockSync",
                table: "Config",
                type: "bit",
                nullable: false,
                defaultValue: false,
                comment: "KRX 주식(마스터+일별) 수집");

            migrationBuilder.AddColumn<bool>(
                name: "DataCollection_KrxWarrantSync",
                table: "Config",
                type: "bit",
                nullable: false,
                defaultValue: false,
                comment: "KRX 신주인수권 수집");

            migrationBuilder.AddColumn<bool>(
                name: "DataCollection_MarketQuoteEnabled",
                table: "Config",
                type: "bit",
                nullable: false,
                defaultValue: false,
                comment: "주요종목·상품 시세 수집");

            migrationBuilder.AddColumn<string>(
                name: "DataCollection_OpenDartApiKeyEnc",
                table: "Config",
                type: "nvarchar(max)",
                nullable: true,
                comment: "OpenDART crtfc_key (암호화)");

            migrationBuilder.AddColumn<bool>(
                name: "DataCollection_OpenDartDisclosureSync",
                table: "Config",
                type: "bit",
                nullable: false,
                defaultValue: false,
                comment: "OpenDART 공시 수집");

            migrationBuilder.AddColumn<string>(
                name: "DataCollection_SeibroApiKeyEnc",
                table: "Config",
                type: "nvarchar(max)",
                nullable: true,
                comment: "SEIBro key (암호화)");

            migrationBuilder.AddColumn<bool>(
                name: "DataCollection_SeibroBondSync",
                table: "Config",
                type: "bit",
                nullable: false,
                defaultValue: false,
                comment: "SEIBro 채권·단기금융 수집");

            migrationBuilder.AddColumn<bool>(
                name: "DataCollection_SeibroCorpActionSync",
                table: "Config",
                type: "bit",
                nullable: false,
                defaultValue: false,
                comment: "SEIBro 기업행위·총회 수집");

            migrationBuilder.AddColumn<bool>(
                name: "DataCollection_SeibroDerivSync",
                table: "Config",
                type: "bit",
                nullable: false,
                defaultValue: false,
                comment: "SEIBro 파생결합증권 수집");

            migrationBuilder.AddColumn<bool>(
                name: "DataCollection_SeibroDividendSync",
                table: "Config",
                type: "bit",
                nullable: false,
                defaultValue: false,
                comment: "SEIBro 배당·권리 수집");

            migrationBuilder.AddColumn<bool>(
                name: "DataCollection_SeibroForeignSync",
                table: "Config",
                type: "bit",
                nullable: false,
                defaultValue: false,
                comment: "SEIBro 외화증권 수집");

            migrationBuilder.AddColumn<bool>(
                name: "DataCollection_SeibroIssuerSync",
                table: "Config",
                type: "bit",
                nullable: false,
                defaultValue: false,
                comment: "SEIBro 발행회사번호 부트스트랩");

            migrationBuilder.AddColumn<bool>(
                name: "DataCollection_SeibroSupplySync",
                table: "Config",
                type: "bit",
                nullable: false,
                defaultValue: false,
                comment: "SEIBro 수급 이벤트 수집");

            migrationBuilder.AddColumn<bool>(
                name: "DataCollection_StockDataDailyPriceSync",
                table: "Config",
                type: "bit",
                nullable: false,
                defaultValue: false,
                comment: "금융위 일별시세 수집");

            migrationBuilder.AddColumn<bool>(
                name: "DataCollection_StockDataMasterSync",
                table: "Config",
                type: "bit",
                nullable: false,
                defaultValue: false,
                comment: "금융위 종목마스터 수집");

            migrationBuilder.AddColumn<bool>(
                name: "DataCollection_WorldIndexEnabled",
                table: "Config",
                type: "bit",
                nullable: false,
                defaultValue: false,
                comment: "세계지수 수집");

            migrationBuilder.AddColumn<string>(
                name: "External_KakaoAdminKeyEnc",
                table: "Config",
                type: "nvarchar(max)",
                nullable: true,
                comment: "카카오 Admin 키 (암호화)");

            migrationBuilder.AddColumn<string>(
                name: "External_KakaoJavascriptKey",
                table: "Config",
                type: "nvarchar(max)",
                nullable: true,
                comment: "카카오 JavaScript 키");

            migrationBuilder.AddColumn<string>(
                name: "External_KakaoRestApiKeyEnc",
                table: "Config",
                type: "nvarchar(max)",
                nullable: true,
                comment: "카카오 REST API 키 (암호화)");

            migrationBuilder.AddColumn<string>(
                name: "External_NaverClientId",
                table: "Config",
                type: "nvarchar(max)",
                nullable: true,
                comment: "네이버 로그인 Client ID");

            migrationBuilder.AddColumn<string>(
                name: "External_NaverClientSecretEnc",
                table: "Config",
                type: "nvarchar(max)",
                nullable: true,
                comment: "네이버 로그인 Client Secret (암호화)");

            migrationBuilder.AddColumn<string>(
                name: "External_NaverSearchClientId",
                table: "Config",
                type: "nvarchar(max)",
                nullable: true,
                comment: "네이버 검색 API Client ID");

            migrationBuilder.AddColumn<string>(
                name: "External_NaverSearchClientSecretEnc",
                table: "Config",
                type: "nvarchar(max)",
                nullable: true,
                comment: "네이버 검색 API Client Secret (암호화)");
        }

        /// <inheritdoc />
        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropColumn(
                name: "DataCollection_DataGoKrServiceKeyEnc",
                table: "Config");

            migrationBuilder.DropColumn(
                name: "DataCollection_KoreaEximExchangeKeyEnc",
                table: "Config");

            migrationBuilder.DropColumn(
                name: "DataCollection_KoreaEximIntlRateKeyEnc",
                table: "Config");

            migrationBuilder.DropColumn(
                name: "DataCollection_KoreaEximLoanRateKeyEnc",
                table: "Config");

            migrationBuilder.DropColumn(
                name: "DataCollection_KoreaEximMacroSync",
                table: "Config");

            migrationBuilder.DropColumn(
                name: "DataCollection_KosisApiKeyEnc",
                table: "Config");

            migrationBuilder.DropColumn(
                name: "DataCollection_KosisSync",
                table: "Config");

            migrationBuilder.DropColumn(
                name: "DataCollection_KrxApiKeyEnc",
                table: "Config");

            migrationBuilder.DropColumn(
                name: "DataCollection_KrxBondIndexSync",
                table: "Config");

            migrationBuilder.DropColumn(
                name: "DataCollection_KrxBondSync",
                table: "Config");

            migrationBuilder.DropColumn(
                name: "DataCollection_KrxCommoditySync",
                table: "Config");

            migrationBuilder.DropColumn(
                name: "DataCollection_KrxDerivativeSync",
                table: "Config");

            migrationBuilder.DropColumn(
                name: "DataCollection_KrxEsgSync",
                table: "Config");

            migrationBuilder.DropColumn(
                name: "DataCollection_KrxEtpSync",
                table: "Config");

            migrationBuilder.DropColumn(
                name: "DataCollection_KrxIndexSync",
                table: "Config");

            migrationBuilder.DropColumn(
                name: "DataCollection_KrxStockSync",
                table: "Config");

            migrationBuilder.DropColumn(
                name: "DataCollection_KrxWarrantSync",
                table: "Config");

            migrationBuilder.DropColumn(
                name: "DataCollection_MarketQuoteEnabled",
                table: "Config");

            migrationBuilder.DropColumn(
                name: "DataCollection_OpenDartApiKeyEnc",
                table: "Config");

            migrationBuilder.DropColumn(
                name: "DataCollection_OpenDartDisclosureSync",
                table: "Config");

            migrationBuilder.DropColumn(
                name: "DataCollection_SeibroApiKeyEnc",
                table: "Config");

            migrationBuilder.DropColumn(
                name: "DataCollection_SeibroBondSync",
                table: "Config");

            migrationBuilder.DropColumn(
                name: "DataCollection_SeibroCorpActionSync",
                table: "Config");

            migrationBuilder.DropColumn(
                name: "DataCollection_SeibroDerivSync",
                table: "Config");

            migrationBuilder.DropColumn(
                name: "DataCollection_SeibroDividendSync",
                table: "Config");

            migrationBuilder.DropColumn(
                name: "DataCollection_SeibroForeignSync",
                table: "Config");

            migrationBuilder.DropColumn(
                name: "DataCollection_SeibroIssuerSync",
                table: "Config");

            migrationBuilder.DropColumn(
                name: "DataCollection_SeibroSupplySync",
                table: "Config");

            migrationBuilder.DropColumn(
                name: "DataCollection_StockDataDailyPriceSync",
                table: "Config");

            migrationBuilder.DropColumn(
                name: "DataCollection_StockDataMasterSync",
                table: "Config");

            migrationBuilder.DropColumn(
                name: "DataCollection_WorldIndexEnabled",
                table: "Config");

            migrationBuilder.DropColumn(
                name: "External_KakaoAdminKeyEnc",
                table: "Config");

            migrationBuilder.DropColumn(
                name: "External_KakaoJavascriptKey",
                table: "Config");

            migrationBuilder.DropColumn(
                name: "External_KakaoRestApiKeyEnc",
                table: "Config");

            migrationBuilder.DropColumn(
                name: "External_NaverClientId",
                table: "Config");

            migrationBuilder.DropColumn(
                name: "External_NaverClientSecretEnc",
                table: "Config");

            migrationBuilder.DropColumn(
                name: "External_NaverSearchClientId",
                table: "Config");

            migrationBuilder.DropColumn(
                name: "External_NaverSearchClientSecretEnc",
                table: "Config");
        }
    }
}