현성필
20 lines
946 B
SQL
20 lines
946 B
SQL
-- 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 참조)';
|