CREATE TABLE IF NOT EXISTS `missions` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `title` VARCHAR(255) NOT NULL,
  `description` TEXT,
  `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- Insert some dummy data for initial view
INSERT INTO `missions` (`title`, `description`) VALUES
('The Faces of Lacedonia', 'Explore the portraits of 1957 and learn the stories of the people.'),
('A Journey Through Time', 'Compare the Lacedonia of the past with the town of today.'),
('Artisans and Crafts', 'Discover the traditional crafts and tools used by the people of Irpinia.');
