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';