-- Add type column to gallery_categories table
ALTER TABLE `gallery_categories` 
ADD COLUMN `type` ENUM('interior', 'exterior', 'amenities', 'floor_plan', 'other') DEFAULT 'other' AFTER `name`,
MODIFY COLUMN `name` varchar(100) NOT NULL AFTER `id`;

-- Add an index on the type column for better performance
CREATE INDEX `idx_category_type` ON `gallery_categories` (`type`);
