CREATE TABLE IF NOT EXISTS `persons` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `name` VARCHAR(255) NOT NULL,
  `title` VARCHAR(255),
  `bio` TEXT,
  `email` VARCHAR(255),
  `phone` VARCHAR(50),
  `image_url` VARCHAR(255),
  `display_order` INT DEFAULT 0,
  `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- Insert some seed data
INSERT INTO `persons` (`name`, `title`, `bio`, `email`, `phone`, `image_url`, `display_order`) VALUES
('John Anderson', 'Chief Executive Officer', 'John has over 20 years of experience in architecture and business leadership. He founded RMA with a vision to create sustainable, innovative spaces.', 'john.anderson@rma.com', '+1 (555) 123-4567', 'https://picsum.photos/600/800?random=101', 1),
('Maria Garcia', 'Chief Financial Officer', 'Maria brings extensive financial expertise and strategic planning skills to ensure RMA\'s continued growth and stability.', 'maria.garcia@rma.com', '+1 (555) 234-5678', 'https://picsum.photos/600/800?random=102', 2),
('David Kim', 'Director of Operations', 'David oversees all operational aspects of RMA, ensuring projects are delivered on time and exceed client expectations.', 'david.kim@rma.com', '+1 (555) 345-6789', 'https://picsum.photos/600/800?random=103', 3),
('Lisa Thompson', 'Head of Human Resources', 'Lisa is passionate about creating a positive work culture and developing talent within the organization.', 'lisa.thompson@rma.com', '+1 (555) 456-7890', 'https://picsum.photos/600/800?random=104', 4);
