
ALTER TABLE restaurants
ADD COLUMN opening_time TIME,
ADD COLUMN closing_time TIME,
ADD COLUMN days_open VARCHAR(255);

-- Update existing restaurants with some default hours (e.g., 9 AM to 9 PM, open all week)
UPDATE restaurants SET
    opening_time = '09:00:00',
    closing_time = '21:00:00',
    days_open = 'Mon,Tue,Wed,Thu,Fri,Sat,Sun';
