-- MariaDB SQL Migration for Advanced Waiter Status Management
-- This script updates the status enum and sets the default value to 'Inactive'.

ALTER TABLE waiters
MODIFY COLUMN status ENUM('Inactive', 'Active', 'Break', 'Off-Duty', 'Suspended', 'Weekly-Off', 'Deleted') DEFAULT 'Inactive';