-- Migration: Add project soft delete
-- Date: 2025-12-XX
-- Description: Adds soft delete column to projects

-- ===== Extend Projects Table =====
-- Add soft delete column to projects
ALTER TABLE projects
ADD COLUMN deleted_at TIMESTAMP NULL DEFAULT NULL COMMENT '削除日時（soft delete）';

-- Add index for deleted_at
ALTER TABLE projects
ADD INDEX idx_deleted_at (deleted_at);


