DO $$
BEGIN
  IF to_regclass('public.launcher_notices') IS NOT NULL THEN
    ALTER TABLE "launcher_notices"
    ADD COLUMN IF NOT EXISTS "created_by_id" UUID,
    ADD COLUMN IF NOT EXISTS "created_by_name" TEXT,
    ADD COLUMN IF NOT EXISTS "created_by_email" TEXT;
  END IF;
END $$;

DO $$
BEGIN
  IF to_regclass('public.launcher_notices') IS NOT NULL THEN
    CREATE INDEX IF NOT EXISTS "launcher_notices_created_by_email_idx" ON "launcher_notices"("created_by_email");
  END IF;
END $$;