🛠️Installation

1. Run the sql: m_crafting

CREATE TABLE IF NOT EXISTS `m_crafting` (
  `identifier` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `experience` int DEFAULT '0',
  PRIMARY KEY (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE IF NOT EXISTS `m_crafting_favorites` (
  `identifier` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `favorites` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `created_at` timestamp DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`identifier`),
  CONSTRAINT `favorites_json_check` CHECK (json_valid(`favorites`))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE IF NOT EXISTS `m_crafting_achievements` (
    `identifier` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
    `achievement_id` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
    `progress` int DEFAULT '0',
    `completed` tinyint(1) DEFAULT '0',
    `completed_at` timestamp NULL DEFAULT NULL,
    `data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
    PRIMARY KEY (`identifier`, `achievement_id`),
    CONSTRAINT `achievement_data_json_check` CHECK (json_valid(`data`))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE IF NOT EXISTS `m_crafting_stats` (
    `identifier` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
    `total_crafted` int DEFAULT '0',
    `items_by_category` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
    `last_craft_date` date DEFAULT NULL,
    `daily_streak` int DEFAULT '0',
    `created_at` timestamp DEFAULT CURRENT_TIMESTAMP,
    `updated_at` timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`identifier`),
    CONSTRAINT `items_category_json_check` CHECK (json_valid(`items_by_category`))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;