CREATE TABLE IF NOT EXISTS venues (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(255) NOT NULL,
    description TEXT,
    image_url VARCHAR(255),
    capacity INT,
    features VARCHAR(255),
    status ENUM('Available', 'Booked') DEFAULT 'Available'
);

-- Seed data
INSERT INTO venues (name, description, image_url, capacity, features, status) VALUES
('The Grand Ballroom', 'A spacious and elegant hall perfect for large corporate events and weddings. Features high ceilings and crystal chandeliers.', 'https://picsum.photos/seed/venue-hall/800/600', 500, 'AV System,Catering,On-site Parking', 'Available'),
('The Secret Garden', 'A beautiful outdoor garden venue, ideal for romantic weddings and intimate gatherings. Surrounded by lush greenery.', 'https://picsum.photos/seed/venue-garden/800/600', 150, 'Outdoor Seating,Sound System,Pet Friendly', 'Available'),
('The Metro Loft', 'A modern, industrial loft with exposed brick and large windows, offering a unique backdrop for any event.', 'https://picsum.photos/seed/venue-loft/800/600', 200, 'Wi-Fi,Projector,Rooftop Access', 'Booked'),
('Lakeside Pavilion', 'A serene pavilion by the lake, offering stunning views and a tranquil atmosphere for retreats and special occasions.', 'https://picsum.photos/seed/venue-pavilion/800/600', 100, 'Waterfront,Kitchenette,Wheelchair Accessible', 'Available');
