CREATE TABLE IF NOT EXISTS `nord_crafting_settings` (
  `setting_key` varchar(64) NOT NULL,
  `setting_value` longtext DEFAULT NULL,
  PRIMARY KEY (`setting_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE IF NOT EXISTS `nord_crafting_blueprints` (
  `id` varchar(60) NOT NULL,
  `label` varchar(100) NOT NULL,
  `item` varchar(100) NOT NULL,
  `ingredients` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`ingredients`)),
  `max_uses` int(11) NOT NULL DEFAULT 1,
  `image` text DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `amount` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

CREATE TABLE IF NOT EXISTS `nord_crafting_fixed` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `label` varchar(64) NOT NULL,
  `model` varchar(64) NOT NULL,
  `x` double NOT NULL,
  `y` double NOT NULL,
  `z` double NOT NULL,
  `heading` double NOT NULL DEFAULT 0,
  `access_json` longtext NOT NULL,
  `recipes_json` longtext NOT NULL,
  `stash_enabled` tinyint(1) NOT NULL DEFAULT 1,
  `stash_slots` int(11) NOT NULL DEFAULT 30,
  `stash_weight` int(11) NOT NULL DEFAULT 40000,
  `created_by` varchar(64) NOT NULL,
  `created_at` bigint(20) NOT NULL,
  `type` varchar(20) DEFAULT 'craft',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=122 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

CREATE TABLE IF NOT EXISTS `nord_crafting_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(50) NOT NULL,
  `player_cid` varchar(64) DEFAULT NULL,
  `bench_id` varchar(50) DEFAULT NULL,
  `message` text NOT NULL,
  `created_at` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE IF NOT EXISTS `nord_crafting_placed` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `owner_cid` varchar(64) NOT NULL,
  `label` varchar(100) DEFAULT 'Bancada Portátil',
  `model` varchar(64) NOT NULL,
  `x` double NOT NULL,
  `y` double NOT NULL,
  `z` double NOT NULL,
  `heading` double NOT NULL DEFAULT 0,
  `access_json` longtext NOT NULL,
  `recipes_json` longtext NOT NULL,
  `stash_enabled` tinyint(1) NOT NULL DEFAULT 1,
  `stash_slots` int(11) NOT NULL DEFAULT 20,
  `stash_weight` int(11) NOT NULL DEFAULT 20000,
  `expires_at` bigint(20) DEFAULT NULL,
  `created_at` bigint(20) NOT NULL,
  `type` varchar(20) DEFAULT 'craft',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

CREATE TABLE IF NOT EXISTS `nord_crafting_props` (
  `id` varchar(100) NOT NULL,
  `label` varchar(100) NOT NULL,
  `image` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

CREATE TABLE IF NOT EXISTS `nord_crafting_recipes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `recipe_id` varchar(64) DEFAULT NULL,
  `label` varchar(100) NOT NULL,
  `item` varchar(100) NOT NULL,
  `amount` int(11) NOT NULL DEFAULT 1,
  `time` int(11) NOT NULL DEFAULT 5000,
  `ingredients` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`ingredients`)),
  `recipe_type` varchar(30) NOT NULL DEFAULT 'other',
  `created_by` varchar(64) DEFAULT NULL,
  `created_at` bigint(20) DEFAULT NULL,
  `use_blueprint` tinyint(1) NOT NULL DEFAULT 0,
  `blueprint_type` varchar(50) DEFAULT NULL,
  `use_level` tinyint(1) NOT NULL DEFAULT 0,
  `min_level` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `recipe_id` (`recipe_id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

CREATE TABLE IF NOT EXISTS `nord_crafting_levels` (
  `level` int(11) NOT NULL,
  `xp_required` int(11) NOT NULL DEFAULT 0,
  `label` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE IF NOT EXISTS `nord_crafting_player_levels` (
  `identifier` varchar(64) NOT NULL,
  `xp` int(11) NOT NULL DEFAULT 0,
  `level` int(11) NOT NULL DEFAULT 1,
  `updated_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE IF NOT EXISTS `nord_craft_benches` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `label` varchar(80) NOT NULL,
  `bench_type` varchar(50) NOT NULL DEFAULT 'general',
  `model` varchar(80) NOT NULL DEFAULT 'gr_prop_gr_bench_04b',
  `coords` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`coords`)),
  `heading` float NOT NULL DEFAULT 0,
  `owner` varchar(64) DEFAULT NULL,
  `access` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`access`)),
  `recipe_ids` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`recipe_ids`)),
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE IF NOT EXISTS `nord_craft_recipes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `label` varchar(80) NOT NULL,
  `category` varchar(50) NOT NULL DEFAULT 'General',
  `output_item` varchar(80) NOT NULL,
  `output_amount` int(11) NOT NULL DEFAULT 1,
  `ingredients` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`ingredients`)),
  `craft_time` int(11) NOT NULL DEFAULT 7000,
  `access` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`access`)),
  `meta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`meta`)),
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;