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,
PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8mb3_general_ci';
ALTER TABLE `users` ADD IF NOT EXISTS `crafting_skill` LONGTEXT NULL DEFAULT NULL;
DELIMITER $$
CREATE PROCEDURE migrate_crafting_tables()
BEGIN
IF EXISTS (
SELECT * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'crafting_tables'
AND COLUMN_NAME = 'job'
AND TABLE_SCHEMA = DATABASE()
) THEN
ALTER TABLE `crafting_tables`
DROP COLUMN `job`,
DROP COLUMN `grades`,
DROP COLUMN `gang`,
DROP COLUMN `gangGrades`;
ALTER TABLE `crafting_tables`
ADD COLUMN `jobs` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
ADD COLUMN `gangs` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci';
END IF;
END$$
DELIMITER ;
CALL migrate_crafting_tables();
DROP PROCEDURE IF EXISTS migrate_crafting_tables;
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,
PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8mb3_general_ci';
ALTER TABLE `players` ADD IF NOT EXISTS `crafting_skill` LONGTEXT NULL DEFAULT NULL;
DELIMITER $$
CREATE PROCEDURE migrate_crafting_tables()
BEGIN
IF EXISTS (
SELECT * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'crafting_tables'
AND COLUMN_NAME = 'job'
AND TABLE_SCHEMA = DATABASE()
) THEN
ALTER TABLE `crafting_tables`
DROP COLUMN `job`,
DROP COLUMN `grades`,
DROP COLUMN `gang`,
DROP COLUMN `gangGrades`;
ALTER TABLE `crafting_tables`
ADD COLUMN `jobs` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
ADD COLUMN `gangs` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci';
END IF;
END$$
DELIMITER ;
CALL migrate_crafting_tables();
DROP PROCEDURE IF EXISTS migrate_crafting_tables;
/crafting_creator