<?php
/// file: database/migrations/008_create_seo_meta.php

declare(strict_types=1);


return static function (PDO $pdo): void {
    $pdo->exec('CREATE TABLE IF NOT EXISTS seo_meta (
      id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
      page_key VARCHAR(120) NOT NULL UNIQUE,
      title VARCHAR(255) NOT NULL DEFAULT "",
      description TEXT NOT NULL,
      og_title VARCHAR(255) NOT NULL DEFAULT "",
      og_description TEXT NOT NULL,
      og_image VARCHAR(512) NOT NULL DEFAULT "",
      robots VARCHAR(120) NOT NULL DEFAULT "index,follow",
      structured_json TEXT NULL,
      updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci');
};
