CREATE TABLE IF NOT EXISTS `okokpolicejob_reports` (`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,`reporter`VARCHAR(255) NOT NULL,`phone`VARCHAR(255) NOT NULL,`date`VARCHAR(255) NOT NULL,`description`TEXT NOT NULL,`status` INT NOT NULL DEFAULT '0');ALTER TABLE `users`DROP COLUMN IF EXISTS `ankleMonitor`,ADD COLUMN `ankleMonitor` BOOLEAN NOT NULL DEFAULT '0',DROP COLUMN IF EXISTS `isHandcuffed`,ADD COLUMN `isHandcuffed` BOOLEAN NOT NULL DEFAULT '0',DROP COLUMN IF EXISTS `jailTime`,ADD COLUMN `jailTime` INT NOT NULL DEFAULT '0',DROP COLUMN IF EXISTS `communityService`,ADD COLUMN `communityService` INT NOT NULL DEFAULT '0';INSERT INTO `items` (`name`, `label`, `weight`, `rare`, `can_remove`) VALUES ('handcuffs', 'Handcuffs', 1, 1, 1);
CREATE TABLE IF NOT EXISTS `okokpolicejob_reports` (`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,`reporter`VARCHAR(255) NOT NULL,`phone`VARCHAR(255) NOT NULL,`date`VARCHAR(255) NOT NULL,`description`TEXT NOT NULL,`status` INT NOT NULL DEFAULT '0');ALTER TABLE `players`DROP COLUMN IF EXISTS `ankleMonitor`,ADD COLUMN `ankleMonitor` BOOLEAN NOT NULL DEFAULT '0',DROP COLUMN IF EXISTS `isHandcuffed`,ADD COLUMN `isHandcuffed` BOOLEAN NOT NULL DEFAULT '0',DROP COLUMN IF EXISTS `jailTime`,ADD COLUMN `jailTime` INT NOT NULL DEFAULT '0',DROP COLUMN IF EXISTS `communityService`,ADD COLUMN `communityService` INT NOT NULL DEFAULT '0';