CREATE TABLE IF NOT EXISTS `categories` (
    `id`          INT UNSIGNED NOT NULL AUTO_INCREMENT,
    `name_lv`     VARCHAR(100) NOT NULL,
    `name_ru`     VARCHAR(100) NOT NULL,
    `name_en`     VARCHAR(100) NOT NULL,
    `slug`        VARCHAR(100) NOT NULL,
    `description_lv` TEXT NULL,
    `description_ru` TEXT NULL,
    `description_en` TEXT NULL,
    `icon`        VARCHAR(50) NULL COMMENT 'Emoji or icon class',
    `is_active`   TINYINT(1) NOT NULL DEFAULT 1,
    `sort_order`  INT NOT NULL DEFAULT 0,
    `created_at`  DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `categories_slug_unique` (`slug`),
    KEY `categories_is_active_index` (`is_active`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
