-- 1. 기존 테이블 삭제 (데이터 백업 후!)
-- 백업 예: CREATE TABLE MEMBERS_BAK AS SELECT * FROM MEMBERS;
DROP TABLE MEMBERS;

-- 2. APEX 캐시 클리어
BEGIN
  APEX_UTIL.CLEAR_APP_CACHE;
  APEX_UTIL.CLEAR_WORKSPACE_CACHE;
END;
/

-- 3. 테이블 재생성
CREATE TABLE MEMBERS 
   (	ID NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY PRIMARY KEY, 
    MEMBER_NUMBER NUMBER, 
    LAST_NAME VARCHAR2(100), 
    FIRST_NAME VARCHAR2(100), 
    DOB DATE, 
    GENDER VARCHAR2(1), 
    ROLE NUMBER, 
    ENGLISH_NAME VARCHAR2(100), 
    ADDRESS VARCHAR2(255), 
    CITY VARCHAR2(50), 
    STATE VARCHAR2(50), 
    ZIP NUMBER(5,0), 
    PHONE VARCHAR2(50), 
    GROUP_A VARCHAR2(20), 
    GROUP_B VARCHAR2(20), 
    PHOTO BLOB, 
    PHOTO_MIMETYPE VARCHAR2(50), 
    PHOTO_FILENAME VARCHAR2(255),
    PHOTO_SIZE NUMBER
   ) 
   LOB (PHOTO) STORE AS SECUREFILE (
     COMPRESS MEDIUM CACHE DEDUPLICATE
   );

-- 4. 제약조건
ALTER TABLE MEMBERS 
  ADD CONSTRAINT CHK_PHOTO_SIZE CHECK (PHOTO_SIZE <= 52428800);