-- Add is_staff column to members table
-- Run this migration to add staff tracking to existing databases

ALTER TABLE `members`
    ADD COLUMN `is_staff` BOOLEAN DEFAULT FALSE AFTER `notes`;

-- Index for filtering staff members
ALTER TABLE `members`
    ADD INDEX `idx_members_staff` (`tenant_id`, `is_staff`, `deleted_at`);