Add soft deletes via status column #15
Reference in New Issue
Block a user
Delete Branch "feature/soft-deletes"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
- Add status ENUM('active','disabled','deleted') to 8 tables - Change all physical DELETE to UPDATE status='deleted' - All SELECT queries filter by status='active' - toggleActive now alternates between active/disabled status - Exceptions: monitoring_history, rate_limits, sessions keep physical purge - audit_logs remains immutable