CREATE TABLE IF NOT EXISTS `team_members` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `name` VARCHAR(255) NOT NULL,
  `role` VARCHAR(255) NOT NULL,
  `image_url` VARCHAR(255),
  `display_order` INT DEFAULT 0,
  `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- Insert some seed data
INSERT INTO `team_members` (`name`, `role`, `image_url`, `display_order`) VALUES
('Sarah Jenkins', 'Principal Architect', 'https://picsum.photos/600/800?random=1', 1),
('David Chen', 'Design Director', 'https://picsum.photos/600/800?random=2', 2),
('Elena Rodriguez', 'Senior Interior Designer', 'https://picsum.photos/600/800?random=3', 3),
('Michael Chang', 'Project Manager', 'https://picsum.photos/600/800?random=4', 4),
('Jessica Alverez', 'Landscape Architect', 'https://picsum.photos/600/800?random=5', 5),
('Robert Fox', '3D Visualization Artist', 'https://picsum.photos/600/800?random=6', 6),
('Emily White', 'Junior Architect', 'https://picsum.photos/600/800?random=7', 7),
('James Wilson', 'Sustainability Consultant', 'https://picsum.photos/600/800?random=8', 8);