📃SQL

SQL file needed when automatic database creation does not work properly

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;