-- MariaDB SQL Migration for Advanced Waiter Management
-- This script adds the advanced fields to the 'waiters' table.

ALTER TABLE waiters
ADD COLUMN mobile_number VARCHAR(20) DEFAULT NULL AFTER name,
ADD COLUMN email VARCHAR(100) DEFAULT NULL AFTER mobile_number,
ADD COLUMN address TEXT DEFAULT NULL AFTER email;