# Database

```sql
CREATE TABLE `koja-crafting` (
  `identifier` varchar(100) NOT NULL,
  `blueprints` longtext DEFAULT NULL,
  `level` int(11) NOT NULL DEFAULT 1,
  `exp` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `koja-crafting-objects` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `craftingId` varchar(100) NOT NULL,
  `model` varchar(100) NOT NULL,
  `x` float NOT NULL,
  `y` float NOT NULL,
  `z` float NOT NULL,
  `heading` float NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

CREATE TABLE `koja-crafting-queue` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `identifier` varchar(100) NOT NULL,
  `craftingTableId` varchar(100) DEFAULT NULL,
  `itemName` varchar(100) NOT NULL,
  `itemImage` varchar(255) DEFAULT NULL,
  `amount` int(11) NOT NULL DEFAULT 1,
  `craftingAmount` int(11) NOT NULL DEFAULT 1,
  `exp` int(11) NOT NULL DEFAULT 0,
  `startTime` bigint(20) NOT NULL,
  `endTime` bigint(20) NOT NULL,
  `craftingTime` int(11) NOT NULL,
  `completed` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `idx_identifier` (`identifier`),
  KEY `idx_craftingTableId` (`craftingTableId`),
  KEY `idx_completed` (`completed`),
  KEY `idx_endTime` (`endTime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;
```

## Related pages

- [General Settings](/new/crafting/configuration/general-settings) — This page covers the basic configuration options for Koja-Crafting that control debug mode, language, and player behavior.
- [Server Settings](/new/crafting/configuration/server-settings) — This page covers server-side configuration options including database management, crafting recovery, and shared table functionality.
- [Images Settings](/new/crafting/configuration/images-settings) — This page explains how to configure item images, add custom graphics, and manage image paths in Koja-Crafting.
- [Player Progression Settings](/new/crafting/configuration/player-progression-settings) — This page covers the player progression system including levels, experience points, and how to configure the leveling system in Koja-Crafting.
- [Admin Settings](/new/crafting/configuration/admin-settings) — This page covers admin permission configuration and available admin commands for managing Koja-Crafting.
- [Interaction Settings](/new/crafting/configuration/interaction-settings) — This page covers how players interact with crafting stations - either through key press or target system (ox\_target,qb-target,).
- [Configuration](/new/crafting/configuration) — back to the section overview