===== 폐기 반출 시스템 고도화 =====

━━━━━━━━━━━━━━━━━━━━━━━━━━
Step 1: products 테이블 업데이트
━━━━━━━━━━━━━━━━━━━━━━━━━━
ℹ️  cost_price 컬럼이 이미 존재합니다

━━━━━━━━━━━━━━━━━━━━━━━━━━
Step 2: disposal_removals 테이블 업데이트
━━━━━━━━━━━━━━━━━━━━━━━━━━
<br />
<b>Warning</b>:  mysqli::query(): (42S21/1060): Duplicate column name 'total_cost_loss' in <b>C:\laragon\www\wms\run_enhance_disposal_system.php</b> on line <b>60</b><br />
  ℹ️  total_cost_loss (이미 존재)
<br />
<b>Warning</b>:  mysqli::query(): (42S21/1060): Duplicate column name 'total_revenue_loss' in <b>C:\laragon\www\wms\run_enhance_disposal_system.php</b> on line <b>60</b><br />
  ℹ️  total_revenue_loss (이미 존재)
<br />
<b>Warning</b>:  mysqli::query(): (42S21/1060): Duplicate column name 'total_margin_loss' in <b>C:\laragon\www\wms\run_enhance_disposal_system.php</b> on line <b>60</b><br />
  ℹ️  total_margin_loss (이미 존재)
<br />
<b>Warning</b>:  mysqli::query(): (42S21/1060): Duplicate column name 'requires_approval' in <b>C:\laragon\www\wms\run_enhance_disposal_system.php</b> on line <b>60</b><br />
  ℹ️  requires_approval (이미 존재)
<br />
<b>Warning</b>:  mysqli::query(): (42S21/1060): Duplicate column name 'approval_level' in <b>C:\laragon\www\wms\run_enhance_disposal_system.php</b> on line <b>60</b><br />
  ℹ️  approval_level (이미 존재)
<br />
<b>Warning</b>:  mysqli::query(): (42S21/1060): Duplicate column name 'approval_status' in <b>C:\laragon\www\wms\run_enhance_disposal_system.php</b> on line <b>60</b><br />
  ℹ️  approval_status (이미 존재)
<br />
<b>Warning</b>:  mysqli::query(): (42S21/1060): Duplicate column name 'approved_by' in <b>C:\laragon\www\wms\run_enhance_disposal_system.php</b> on line <b>60</b><br />
  ℹ️  approved_by (이미 존재)
<br />
<b>Warning</b>:  mysqli::query(): (42S21/1060): Duplicate column name 'approved_at' in <b>C:\laragon\www\wms\run_enhance_disposal_system.php</b> on line <b>60</b><br />
  ℹ️  approved_at (이미 존재)
<br />
<b>Warning</b>:  mysqli::query(): (42S21/1060): Duplicate column name 'rejection_reason' in <b>C:\laragon\www\wms\run_enhance_disposal_system.php</b> on line <b>60</b><br />
  ℹ️  rejection_reason (이미 존재)
<br />
<b>Warning</b>:  mysqli::query(): (42S21/1060): Duplicate column name 'photos' in <b>C:\laragon\www\wms\run_enhance_disposal_system.php</b> on line <b>60</b><br />
  ℹ️  photos (이미 존재)
<br />
<b>Warning</b>:  mysqli::query(): (42S21/1060): Duplicate column name 'preferred_date' in <b>C:\laragon\www\wms\run_enhance_disposal_system.php</b> on line <b>60</b><br />
  ℹ️  preferred_date (이미 존재)
<br />
<b>Warning</b>:  mysqli::query(): (42S21/1060): Duplicate column name 'preferred_time' in <b>C:\laragon\www\wms\run_enhance_disposal_system.php</b> on line <b>60</b><br />
  ℹ️  preferred_time (이미 존재)
<br />
<b>Warning</b>:  mysqli::query(): (42S21/1060): Duplicate column name 'vehicle_info' in <b>C:\laragon\www\wms\run_enhance_disposal_system.php</b> on line <b>60</b><br />
  ℹ️  vehicle_info (이미 존재)
<br />
<b>Warning</b>:  mysqli::query(): (42S21/1060): Duplicate column name 'actual_removal_date' in <b>C:\laragon\www\wms\run_enhance_disposal_system.php</b> on line <b>60</b><br />
  ℹ️  actual_removal_date (이미 존재)
<br />
<b>Warning</b>:  mysqli::query(): (42S21/1060): Duplicate column name 'removal_cost' in <b>C:\laragon\www\wms\run_enhance_disposal_system.php</b> on line <b>60</b><br />
  ℹ️  removal_cost (이미 존재)
<br />
<b>Warning</b>:  mysqli::query(): (42S21/1060): Duplicate column name 'notification_sent' in <b>C:\laragon\www\wms\run_enhance_disposal_system.php</b> on line <b>60</b><br />
  ℹ️  notification_sent (이미 존재)
<br />
<b>Warning</b>:  mysqli::query(): (42S21/1060): Duplicate column name 'notified_at' in <b>C:\laragon\www\wms\run_enhance_disposal_system.php</b> on line <b>60</b><br />
  ℹ️  notified_at (이미 존재)

추가: 0, 건너뛰기: 17

━━━━━━━━━━━━━━━━━━━━━━━━━━
Step 3: 인덱스 추가
━━━━━━━━━━━━━━━━━━━━━━━━━━
<br />
<b>Warning</b>:  mysqli::query(): (42000/1061): Duplicate key name 'idx_disposal_approval_status' in <b>C:\laragon\www\wms\run_enhance_disposal_system.php</b> on line <b>89</b><br />
  ℹ️  idx_disposal_approval_status (이미 존재)
<br />
<b>Warning</b>:  mysqli::query(): (42000/1061): Duplicate key name 'idx_disposal_preferred_date' in <b>C:\laragon\www\wms\run_enhance_disposal_system.php</b> on line <b>89</b><br />
  ℹ️  idx_disposal_preferred_date (이미 존재)
<br />
<b>Warning</b>:  mysqli::query(): (42000/1061): Duplicate key name 'idx_disposal_created_at' in <b>C:\laragon\www\wms\run_enhance_disposal_system.php</b> on line <b>89</b><br />
  ℹ️  idx_disposal_created_at (이미 존재)
<br />
<b>Warning</b>:  mysqli::query(): (42000/1061): Duplicate key name 'idx_disposal_approved_by' in <b>C:\laragon\www\wms\run_enhance_disposal_system.php</b> on line <b>89</b><br />
  ℹ️  idx_disposal_approved_by (이미 존재)

━━━━━━━━━━━━━━━━━━━━━━━━━━
Step 4: vehicles 테이블 생성
━━━━━━━━━━━━━━━━━━━━━━━━━━
✅ vehicles 테이블 생성 성공

━━━━━━━━━━━━━━━━━━━━━━━━━━
Step 5: 승인 임계값 테이블 생성
━━━━━━━━━━━━━━━━━━━━━━━━━━
✅ disposal_approval_thresholds 테이블 생성 성공
<br />
<b>Warning</b>:  mysqli::query(): (22003/1264): Out of range value for column 'max_amount' at row 3 in <b>C:\laragon\www\wms\run_enhance_disposal_system.php</b> on line <b>154</b><br />
━━━━━━━━━━━━━━━━━━━━━━━━━━
최종 확인
━━━━━━━━━━━━━━━━━━━━━━━━━━

주요 컬럼 확인:
  ✅ total_cost_loss
  ✅ total_revenue_loss
  ✅ total_margin_loss
  ✅ approval_status
  ✅ photos
  ✅ preferred_date

━━━━━━━━━━━━━━━━━━━━━━━━━━
🎉 마이그레이션 완료!
━━━━━━━━━━━━━━━━━━━━━━━━━━