ALTER TABLE "launcher_app_versions"
  ADD COLUMN IF NOT EXISTS "repository" TEXT,
  ADD COLUMN IF NOT EXISTS "branch" TEXT,
  ADD COLUMN IF NOT EXISTS "commit_sha" TEXT;

CREATE TABLE IF NOT EXISTS "launcher_common_settings" (
  "id" UUID NOT NULL DEFAULT gen_random_uuid(),
  "key" TEXT NOT NULL,
  "name" TEXT NOT NULL,
  "type" TEXT NOT NULL,
  "value" TEXT NOT NULL,
  "description" TEXT,
  "is_active" BOOLEAN NOT NULL DEFAULT true,
  "is_secret" BOOLEAN NOT NULL DEFAULT false,
  "created_at" TIMESTAMPTZ(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  "updated_at" TIMESTAMPTZ(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  CONSTRAINT "launcher_common_settings_pkey" PRIMARY KEY ("id")
);

CREATE UNIQUE INDEX IF NOT EXISTS "launcher_common_settings_key_key"
  ON "launcher_common_settings"("key");

CREATE INDEX IF NOT EXISTS "launcher_common_settings_type_is_active_idx"
  ON "launcher_common_settings"("type", "is_active");

COMMENT ON TABLE "launcher_common_settings" IS '런처 공통 연결 설정과 플랫폼 연동 설정';
COMMENT ON COLUMN "launcher_common_settings"."key" IS '공통 설정 식별 키';
COMMENT ON COLUMN "launcher_common_settings"."name" IS '공통 설정 표시 이름';
COMMENT ON COLUMN "launcher_common_settings"."type" IS '공통 설정 유형';
COMMENT ON COLUMN "launcher_common_settings"."value" IS '공통 설정 값';
COMMENT ON COLUMN "launcher_common_settings"."description" IS '공통 설정 설명';
COMMENT ON COLUMN "launcher_common_settings"."is_active" IS '공통 설정 활성 여부';
COMMENT ON COLUMN "launcher_common_settings"."is_secret" IS '민감 정보 여부';