-- magazine_articles 테이블에 'deleted' 상태 추가
-- 로컬 및 서버 모두 실행 필요

-- 1. status 컬럼에 'deleted' ENUM 값 추가
ALTER TABLE magazine_articles 
MODIFY status ENUM('draft','published','featured','archived','deleted') DEFAULT 'draft';

-- 2. 확인
SELECT COLUMN_TYPE 
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE TABLE_NAME = 'magazine_articles' 
AND COLUMN_NAME = 'status';

-- 예상 결과:
-- enum('draft','published','featured','archived','deleted')

