[ script:oxmysql] [ERROR] dealership was unable to execute a query!
[ script:oxmysql] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `dealership_hired_players` (
[ script:oxmysql] `dealership_id` VARC' at line 16
[ script:oxmysql] CREATE TABLE IF NOT EXISTS `dealership_balance` (
[ script:oxmysql] `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
[ script:oxmysql] `dealership_id` VARCHAR(50) NOT NULL COLLATE 'latin1_swedish_ci',
[ script:oxmysql] `user_id` VARCHAR(50) NOT NULL COLLATE 'latin1_swedish_ci',
[ script:oxmysql] `description` VARCHAR(255) NOT NULL COLLATE 'latin1_swedish_ci',
[ script:oxmysql] `name` VARCHAR(50) NOT NULL COLLATE 'latin1_swedish_ci',
[ script:oxmysql] `amount` INT(11) UNSIGNED NOT NULL,
[ script:oxmysql] `type` BIT(1) NOT NULL COMMENT '0 = income | 1 = expense',
[ script:oxmysql] `isbuy` BIT(1) NOT NULL,
[ script:oxmysql] `date` INT(11) UNSIGNED NOT NULL,
[ script:oxmysql] PRIMARY KEY (`id`) USING BTREE
[ script:oxmysql] )
[ script:oxmysql] COLLATE='latin1_swedish_ci'
[ script:oxmysql] ENGINE=InnoDB;
[ script:oxmysql]
[ script:oxmysql] CREATE TABLE IF NOT EXISTS `dealership_hired_players` (
[ script:oxmysql] `dealership_id` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_general_ci',
[ script:oxmysql] `user_id` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_general_ci',
[ script:oxmysql] `profile_img` VARCHAR(255) NOT NULL DEFAULT 'https://amar.amr.org.br/packages/trustir/exclusiva/img/user_placeholder.png' COLLATE 'utf8mb4_general_ci',
[ script:oxmysql] `banner_img` VARCHAR(255) NOT NULL DEFAULT 'https://www.bossecurity.com/wp-content/uploads/2018/10/night-time-drive-bys-1024x683.jpg' COLLATE 'utf8mb4_general_ci',
[ script:oxmysql] `name` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_general_ci',
[ script:oxmysql] `jobs_done` INT(11) UNSIGNED NOT NULL DEFAULT '0',
[ script:oxmysql] `timer` INT(11) UNSIGNED NOT NULL,
[ script:oxmysql] PRIMARY KEY (`dealership_id`, `user_id`) USING BTREE
[ script:oxmysql] )
[ script:oxmysql] COLLATE='utf8mb4_general_ci'
[ script:oxmysql] ENGINE=InnoDB;
[ script:oxmysql]
[ script:oxmysql]
[ script:oxmysql] CREATE TABLE IF NOT EXISTS `dealership_owner` (
[ script:oxmysql] `dealership_id` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_general_ci',
[ script:oxmysql] `user_id` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_general_ci',
[ script:oxmysql] `name` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_general_ci',
[ script:oxmysql] `profile_img` VARCHAR(255) NOT NULL DEFAULT 'https://amar.amr.org.br/packages/trustir/exclusiva/img/user_placeholder.png' COLLATE 'utf8mb4_general_ci',
[ script:oxmysql] `banner_img` VARCHAR(255) NOT NULL DEFAULT 'https://www.bossecurity.com/wp-content/uploads/2018/10/night-time-drive-bys-1024x683.jpg' COLLATE 'utf8mb4_general_ci',
[ script:oxmysql] `stock` TEXT NOT NULL COLLATE 'utf8mb4_general_ci',
[ script:oxmysql] `stock_prices` LONGTEXT NOT NULL COLLATE 'utf8mb4_general_ci',
[ script:oxmysql] `stock_sold` TEXT NOT NULL COLLATE 'utf8mb4_unicode_ci',
[ script:oxmysql] `money` INT(11) UNSIGNED NOT NULL DEFAULT '0',
[ script:oxmysql] `total_money_spent` INT(11) UNSIGNED NOT NULL DEFAULT '0',
[ script:oxmysql] `total_money_earned` INT(11) UNSIGNED NOT NULL DEFAULT '0',
[ script:oxmysql] `timer` INT(11) UNSIGNED NOT NULL,
[ script:oxmysql] PRIMARY KEY (`dealership_id`) USING BTREE
[ script:oxmysql] )
[ script:oxmysql] COLLATE='utf8mb4_general_ci'
[ script:oxmysql] ENGINE=InnoDB;
[ script:oxmysql]
[ script:oxmysql] CREATE TABLE IF NOT EXISTS `dealership_requests` (
[ script:oxmysql] `id` INT(11) NOT NULL AUTO_INCREMENT,
[ script:oxmysql] `dealership_id` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_general_ci',
[ script:oxmysql] `user_id` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_general_ci',
[ script:oxmysql] `vehicle` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_general_ci',
[ script:oxmysql] `plate` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_general_ci',
[ script:oxmysql] `request_type` INT(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '0 = sell reques t| 1 = buy request',
[ script:oxmysql] `name` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_general_ci',
[ script:oxmysql] `price` INT(11) UNSIGNED NOT NULL,
[ script:oxmysql] `status` INT(2) UNSIGNED NOT NULL DEFAULT '0' COMMENT '0 = waiting | 1 = in progress | 2 = finished | 3 = cancelled',
[ script:oxmysql] PRIMARY KEY (`id`) USING BTREE,
[ script:oxmysql] UNIQUE INDEX `request` (`user_id`, `vehicle`, `request_type`, `plate`) USING BTREE
[ script:oxmysql] )
[ script:oxmysql] COLLATE='utf8mb4_general_ci'
[ script:oxmysql] ENGINE=InnoDB;
[ script:oxmysql]
[ script:oxmysql] CREATE TABLE IF NOT EXISTS `dealership_stock` (
[ script:oxmysql] `vehicle` VARCHAR(100) NOT NULL COLLATE 'latin1_swedish_ci',
[ script:oxmysql] `amount` INT(11) UNSIGNED NOT NULL DEFAULT '0',
[ script:oxmysql] PRIMARY KEY (`vehicle`) USING BTREE
[ script:oxmysql] )
[ script:oxmysql] COLLATE='latin1_swedish_ci'
[ script:oxmysql] ENGINE=InnoDB;
[ script:oxmysql]