CREATE TABLE IF NOT EXISTS `site_content` (
  `content_key` varchar(50) NOT NULL,
  `content_json` longtext NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`content_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Previous versions of the site content (the 20 most recent are kept) for manual rollback.
CREATE TABLE IF NOT EXISTS `site_content_revisions` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `content_key` varchar(50) NOT NULL,
  `content_json` longtext NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `site_content_revisions_key_index` (`content_key`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;