CREATE TABLE IF NOT EXISTS `pages` (
    `id`          INT UNSIGNED NOT NULL AUTO_INCREMENT,
    `slug`        VARCHAR(120) NOT NULL,
    `title_lv`    VARCHAR(200) NOT NULL,
    `title_ru`    VARCHAR(200) NOT NULL,
    `title_en`    VARCHAR(200) NOT NULL,
    `content_lv`  LONGTEXT NULL,
    `content_ru`  LONGTEXT NULL,
    `content_en`  LONGTEXT NULL,
    `meta_title_lv`  VARCHAR(160) NULL,
    `meta_title_ru`  VARCHAR(160) NULL,
    `meta_title_en`  VARCHAR(160) NULL,
    `meta_desc_lv`   VARCHAR(320) NULL,
    `meta_desc_ru`   VARCHAR(320) NULL,
    `meta_desc_en`   VARCHAR(320) NULL,
    `is_published`   TINYINT(1) NOT NULL DEFAULT 1,
    `created_at`     DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `updated_at`     DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `pages_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
