-- 1. Add fields to ptl_app_request table
ALTER TABLE ptl_app_request ADD app_description VARCHAR2(500);
COMMENT ON COLUMN ptl_app_request.app_description IS '앱 설명';

ALTER TABLE ptl_app_request ADD callback_url VARCHAR2(255);
COMMENT ON COLUMN ptl_app_request.callback_url IS '콜백 URL';

ALTER TABLE ptl_app_request ADD ip_whitelist VARCHAR2(1000);
COMMENT ON COLUMN ptl_app_request.ip_whitelist IS 'IP 화이트리스트 (comma-separated)';

ALTER TABLE ptl_app_request ADD app_icon_file_id VARCHAR2(38);
COMMENT ON COLUMN ptl_app_request.app_icon_file_id IS '앱 아이콘 파일 ID (ptl_file 참조)';

-- 2. Add fields to ptl_credential table
ALTER TABLE ptl_credential ADD app_description VARCHAR2(500);
COMMENT ON COLUMN ptl_credential.app_description IS '앱 설명';

ALTER TABLE ptl_credential ADD app_icon_file_id VARCHAR2(38);
COMMENT ON COLUMN ptl_credential.app_icon_file_id IS '앱 아이콘 파일 ID (ptl_file 참조)';
