ALTER TABLE
`users`
ADD
IF NOT EXISTS `shell_garage` TEXT NULL DEFAULT '';
DROP TABLE IF EXISTS `owned_vehicles`;
CREATE TABLE `owned_vehicles` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`owner` VARCHAR(255) NOT NULL COLLATE 'utf8mb4_bin',
`tag` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
`plate` VARCHAR(250) NOT NULL COLLATE 'utf8mb4_bin',
`vehicle` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
`type` VARCHAR(20) NOT NULL DEFAULT 'vehicle' COLLATE 'utf8mb4_bin',
`garage` VARCHAR(200) NULL DEFAULT 'OUT' COLLATE 'utf8mb4_bin',
`impound_data` TEXT NULL DEFAULT '' COLLATE 'utf8mb4_bin',
`favorite` INT(3) NOT NULL DEFAULT '0',
`stored` TINYINT(4) NULL DEFAULT '0',
`jobVehicle` VARCHAR(50) NULL DEFAULT '' COLLATE 'utf8mb4_bin',
`jobGarage` VARCHAR(50) NULL DEFAULT '' COLLATE 'utf8mb4_bin',
PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_bin' ENGINE = InnoDB AUTO_INCREMENT = 1;
ALTER TABLE
`owned_vehicles` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
DROP TABLE IF EXISTS `player_garages`;
CREATE TABLE `player_garages` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`creator` VARCHAR(80) NULL DEFAULT NULL,
`owner` VARCHAR(80) NULL DEFAULT NULL,
`name` VARCHAR(50) NULL DEFAULT NULL,
`price` INT(11) NOT NULL,
`coords` LONGTEXT NULL DEFAULT NULL,
`zone` LONGTEXT NULL DEFAULT NULL,
`shell` LONGTEXT NULL DEFAULT NULL,
`type` VARCHAR(50) NULL DEFAULT 'vehicle',
`holders` TEXT NULL DEFAULT NULL,
`available` TINYINT(1) NULL DEFAULT NULL,
`isImpound` TINYINT(1) NULL DEFAULT NULL,
`jobs` LONGTEXT NULL DEFAULT NULL,
`gangs` LONGTEXT NULL DEFAULT NULL,
`interior_type` ENUM('ipl','shell') NOT NULL DEFAULT 'ipl',
PRIMARY KEY (`id`) USING BTREE,
INDEX `creator` (`creator`) USING BTREE
)COLLATE='utf8mb4_unicode_ci';
CREATE TABLE IF NOT EXISTS `qs_garage_decorations` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`insideId` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`creator` VARCHAR(70) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
`modelName` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
`coords` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`rotation` TEXT NOT NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
`inStash` TINYINT(1) NOT NULL DEFAULT '0',
`inside` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`uniq` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`created` TIMESTAMP NULL DEFAULT NULL,
`lightData` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
PRIMARY KEY (`id`) USING BTREE,
INDEX `id` (`id`, `insideId`) USING BTREE
)COLLATE='utf8mb3_general_ci';
DROP TABLE IF EXISTS `qs_garage_furnitures`;
CREATE TABLE `qs_garage_furnitures` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`creator` VARCHAR(80) NULL DEFAULT NULL,
`category_key` VARCHAR(100) NOT NULL,
`object` VARCHAR(200) NOT NULL,
`label` VARCHAR(255) NOT NULL,
`description` TEXT NULL DEFAULT NULL,
`price` INT(11) NOT NULL DEFAULT '0',
`img` TEXT NULL DEFAULT NULL,
`colorlabel` VARCHAR(255) NULL DEFAULT NULL,
`type` VARCHAR(50) NULL DEFAULT NULL,
`stash` LONGTEXT NULL DEFAULT NULL,
`offset` LONGTEXT NULL DEFAULT NULL,
`colors` LONGTEXT NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `creator` (`creator`) USING BTREE,
INDEX `category_key` (`category_key`) USING BTREE
)COLLATE='utf8mb4_unicode_ci' ENGINE=InnoDB;
ALTER TABLE `owned_vehicles`
ADD COLUMN IF NOT EXISTS `impound_data` TEXT NULL DEFAULT '' COLLATE 'utf8mb4_bin',
ADD COLUMN IF NOT EXISTS `favorite` INT(3) NOT NULL DEFAULT '0',
ADD COLUMN IF NOT EXISTS `stored` TINYINT(4) NULL DEFAULT '0',
ADD COLUMN IF NOT EXISTS `jobVehicle` VARCHAR(50) NULL DEFAULT '' COLLATE 'utf8mb4_bin',
ADD COLUMN IF NOT EXISTS `jobGarage` VARCHAR(50) NULL DEFAULT '' COLLATE 'utf8mb4_bin',
ADD COLUMN IF NOT EXISTS `tag` VARCHAR(200) NULL DEFAULT 'OUT' COLLATE 'utf8mb4_bin';
ALTER TABLE `owned_vehicles` ADD COLUMN `hash` BIGINT NULL DEFAULT NULL;
ALTER TABLE `player_garages` ADD IF NOT EXISTS `interior_type` ENUM('ipl','shell') NOT NULL DEFAULT 'ipl';
ALTER TABLE `player_garages` ADD IF NOT EXISTS `enable_open_menu` TINYINT(1) NULL DEFAULT NULL;
ALTER TABLE `player_garages` ADD IF NOT EXISTS `enable_shell_entry` TINYINT(1) NULL DEFAULT NULL;
ALTER TABLE
`users`
ADD
IF NOT EXISTS `shell_garage` TEXT NULL DEFAULT '';
DROP TABLE IF EXISTS `owned_vehicles`;
CREATE TABLE `owned_vehicles` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`owner` VARCHAR(255) NOT NULL COLLATE 'utf8mb4_bin',
`tag` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
`plate` VARCHAR(250) NOT NULL COLLATE 'utf8mb4_bin',
`vehicle` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
`type` VARCHAR(20) NOT NULL DEFAULT 'vehicle' COLLATE 'utf8mb4_bin',
`garage` VARCHAR(200) NULL DEFAULT 'OUT' COLLATE 'utf8mb4_bin',
`impound_data` TEXT NULL DEFAULT '' COLLATE 'utf8mb4_bin',
`favorite` INT(3) NOT NULL DEFAULT '0',
`stored` TINYINT(4) NULL DEFAULT '0',
`jobVehicle` VARCHAR(50) NULL DEFAULT '' COLLATE 'utf8mb4_bin',
`jobGarage` VARCHAR(50) NULL DEFAULT '' COLLATE 'utf8mb4_bin',
PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_bin' ENGINE = InnoDB AUTO_INCREMENT = 1;
ALTER TABLE
`owned_vehicles` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
DROP TABLE IF EXISTS `player_garages`;
CREATE TABLE `player_garages` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`creator` VARCHAR(80) NULL DEFAULT NULL,
`owner` VARCHAR(80) NULL DEFAULT NULL,
`name` VARCHAR(50) NULL DEFAULT NULL,
`price` INT(11) NOT NULL,
`coords` LONGTEXT NULL DEFAULT NULL,
`zone` LONGTEXT NULL DEFAULT NULL,
`shell` LONGTEXT NULL DEFAULT NULL,
`type` VARCHAR(50) NULL DEFAULT 'vehicle',
`holders` TEXT NULL DEFAULT NULL,
`available` TINYINT(1) NULL DEFAULT NULL,
`isImpound` TINYINT(1) NULL DEFAULT NULL,
`jobs` LONGTEXT NULL DEFAULT NULL,
`gangs` LONGTEXT NULL DEFAULT NULL,
`interior_type` ENUM('ipl','shell') NOT NULL DEFAULT 'ipl',
PRIMARY KEY (`id`) USING BTREE,
INDEX `creator` (`creator`) USING BTREE
)COLLATE='utf8mb4_unicode_ci';
CREATE TABLE IF NOT EXISTS `qs_garage_decorations` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`insideId` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`creator` VARCHAR(70) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
`modelName` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
`coords` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`rotation` TEXT NOT NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
`inStash` TINYINT(1) NOT NULL DEFAULT '0',
`inside` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`uniq` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`created` TIMESTAMP NULL DEFAULT NULL,
`lightData` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
PRIMARY KEY (`id`) USING BTREE,
INDEX `id` (`id`, `insideId`) USING BTREE
)COLLATE='utf8mb3_general_ci';
DROP TABLE IF EXISTS `qs_garage_furnitures`;
CREATE TABLE `qs_garage_furnitures` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`creator` VARCHAR(80) NULL DEFAULT NULL,
`category_key` VARCHAR(100) NOT NULL,
`object` VARCHAR(200) NOT NULL,
`label` VARCHAR(255) NOT NULL,
`description` TEXT NULL DEFAULT NULL,
`price` INT(11) NOT NULL DEFAULT '0',
`img` TEXT NULL DEFAULT NULL,
`colorlabel` VARCHAR(255) NULL DEFAULT NULL,
`type` VARCHAR(50) NULL DEFAULT NULL,
`stash` LONGTEXT NULL DEFAULT NULL,
`offset` LONGTEXT NULL DEFAULT NULL,
`colors` LONGTEXT NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `creator` (`creator`) USING BTREE,
INDEX `category_key` (`category_key`) USING BTREE
)COLLATE='utf8mb4_unicode_ci' ENGINE=InnoDB;
ALTER TABLE `owned_vehicles`
ADD COLUMN IF NOT EXISTS `impound_data` TEXT NULL DEFAULT '' COLLATE 'utf8mb4_bin',
ADD COLUMN IF NOT EXISTS `favorite` INT(3) NOT NULL DEFAULT '0',
ADD COLUMN IF NOT EXISTS `stored` TINYINT(4) NULL DEFAULT '0',
ADD COLUMN IF NOT EXISTS `jobVehicle` VARCHAR(50) NULL DEFAULT '' COLLATE 'utf8mb4_bin',
ADD COLUMN IF NOT EXISTS `jobGarage` VARCHAR(50) NULL DEFAULT '' COLLATE 'utf8mb4_bin',
ADD COLUMN IF NOT EXISTS `tag` VARCHAR(200) NULL DEFAULT 'OUT' COLLATE 'utf8mb4_bin';
ALTER TABLE `owned_vehicles` ADD COLUMN `hash` BIGINT NULL DEFAULT NULL;
ALTER TABLE `player_garages` ADD IF NOT EXISTS `interior_type` ENUM('ipl','shell') NOT NULL DEFAULT 'ipl';
ALTER TABLE `player_garages` ADD IF NOT EXISTS `enable_open_menu` TINYINT(1) NULL DEFAULT NULL;
ALTER TABLE `player_garages` ADD IF NOT EXISTS `enable_shell_entry` TINYINT(1) NULL DEFAULT NULL;