DROP TABLE IF EXISTS `crafting_queue`;
DROP TABLE IF EXISTS `crafting_tables`;
CREATE TABLE IF NOT EXISTS `crafting_queue` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`owner` VARCHAR(80) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
`tableId` VARCHAR(30) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`item` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`amount` INT(11) NOT NULL DEFAULT '1',
`startDate` TIMESTAMP NULL DEFAULT NULL,
`duration` INT(11) NULL DEFAULT NULL,
`earn` INT(11) NULL DEFAULT '0',
PRIMARY KEY (`id`) USING BTREE,
INDEX `owner_tableId` (`owner`, `tableId`) USING BTREE
)
COLLATE='utf8mb3_general_ci';
CREATE TABLE IF NOT EXISTS `crafting_tables` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`creator` VARCHAR(80) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
`label` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
`size` SMALLINT(6) NOT NULL DEFAULT '0',
`job` VARCHAR(30) NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
`grades` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`gang` VARCHAR(30) NULL DEFAULT NULL,
`gangGrades` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`object` VARCHAR(50) NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
`coords` LONGTEXT NOT NULL COLLATE 'utf8mb3_general_ci',
`recipes` LONGTEXT NOT NULL COLLATE 'utf8mb4_bin',
`blip` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`global` TINYINT(1) NULL DEFAULT NULL,
`showWeaponsTab` TINYINT(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8mb3_general_ci';
ALTER TABLE `players` ADD IF NOT EXISTS `crafting_skill` LONGTEXT NULL DEFAULT NULL;
ALTER TABLE `crafting_tables` ADD IF NOT EXISTS `jobs` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci';
ALTER TABLE `crafting_tables` ADD IF NOT EXISTS `gangs` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci';
ALTER TABLE `crafting_tables` ADD IF NOT EXISTS `showWeaponsTab` TINYINT(1) NOT NULL DEFAULT '1';
DROP TABLE IF EXISTS `crafting_queue`;
DROP TABLE IF EXISTS `crafting_tables`;
CREATE TABLE IF NOT EXISTS `crafting_queue` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`owner` VARCHAR(80) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
`tableId` VARCHAR(30) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`item` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`amount` INT(11) NOT NULL DEFAULT '1',
`startDate` TIMESTAMP NULL DEFAULT NULL,
`duration` INT(11) NULL DEFAULT NULL,
`earn` INT(11) NULL DEFAULT '0',
PRIMARY KEY (`id`) USING BTREE,
INDEX `owner_tableId` (`owner`, `tableId`) USING BTREE
)
COLLATE='utf8mb3_general_ci';
CREATE TABLE IF NOT EXISTS `crafting_tables` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`creator` VARCHAR(80) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
`label` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
`size` SMALLINT(6) NOT NULL DEFAULT '0',
`job` VARCHAR(30) NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
`grades` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`gang` VARCHAR(30) NULL DEFAULT NULL,
`gangGrades` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`object` VARCHAR(50) NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
`coords` LONGTEXT NOT NULL COLLATE 'utf8mb3_general_ci',
`recipes` LONGTEXT NOT NULL COLLATE 'utf8mb4_bin',
`blip` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`global` TINYINT(1) NULL DEFAULT NULL,
`showWeaponsTab` TINYINT(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8mb3_general_ci';
ALTER TABLE `players` ADD IF NOT EXISTS `crafting_skill` LONGTEXT NULL DEFAULT NULL;
ALTER TABLE `crafting_tables` ADD IF NOT EXISTS `jobs` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci';
ALTER TABLE `crafting_tables` ADD IF NOT EXISTS `gangs` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci';
ALTER TABLE `crafting_tables` ADD IF NOT EXISTS `showWeaponsTab` TINYINT(1) NOT NULL DEFAULT '1';