SQL
ALTER TABLE `players`
ADD COLUMN `image` VARCHAR(250) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
ADD COLUMN `dangerous` TINYINT(4) NULL DEFAULT '0',
ADD COLUMN `wanted` TINYINT(4) UNSIGNED NULL DEFAULT '0';
ALTER TABLE `player_vehicles`
ADD COLUMN `wanted` INT(1) NULL DEFAULT '0',
ADD COLUMN `billPrice` INT(6) NULL DEFAULT '0',
ADD COLUMN `description` LONGTEXT NULL DEFAULT '' COLLATE 'utf8mb4_general_ci';ALTER TABLE `users`
ADD COLUMN `image` VARCHAR(250) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
ADD COLUMN `dangerous` TINYINT(4) NULL DEFAULT '0',
ADD COLUMN `wanted` TINYINT(4) UNSIGNED NULL DEFAULT '0';
ALTER TABLE `owned_vehicles`
ADD COLUMN `wanted` INT(1) NULL DEFAULT '0',
ADD COLUMN `billPrice` INT(6) NULL DEFAULT '0',
ADD COLUMN `description` LONGTEXT NULL DEFAULT '' COLLATE 'utf8mb4_general_ci';
ALTER TABLE `job_grades`
ADD COLUMN `type` VARCHAR(50) NULL DEFAULT 'lspd' COLLATE 'utf8mb3_general_ci';
INSERT INTO `items` (`name`, `label`, `weight`, `rare`, `can_remove`) VALUES
("instant_camera", "Instant camera", 0, 0, 1),
("photo", "Photo", 0, 0, 1),
("evidence_a", "Evidence of", 0, 0, 1),
("evidence_az", "Evidence", 0, 0, 1),
("evidence_b", "Vehicle evidence", 0, 0, 1),
("evidence_n", "Impact evidence", 0, 0, 1),
("evidence_ne", "Footprint evidence", 0, 0, 1),
("evidence_r", "Blood evidence", 0, 0, 1),
("evidence_ro", "Evidence", 0, 0, 1),
("evidence_v", "Drug evidence", 0, 0, 1),
("report_evidence", "Evidence report", 0, 0, 1),
("k9", "K9 whistle", 0, 0, 1),
("lspd_badge", "Police badge", 0, 0, 1),
("bcsd_badge", "Sheriff badge", 0, 0, 1),
("police_cad", "Police tablet", 0, 0, 1),
("megaphone", "Megaphone", 0, 0, 1)
;CREATE TABLE IF NOT EXISTS `origen_police_penalc` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`title` VARCHAR(255) NOT NULL DEFAULT 'Error' COLLATE 'utf8mb4_general_ci',
`description` VARCHAR(255) NOT NULL DEFAULT 'Error' COLLATE 'utf8mb4_general_ci',
`price` INT(11) NOT NULL DEFAULT '0',
`month` INT(11) NOT NULL DEFAULT '0',
`cap` INT(1) NOT NULL DEFAULT '0',
`job` VARCHAR(50) NULL DEFAULT 'police' COLLATE 'utf8mb4_general_ci',
PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
;
CREATE TABLE IF NOT EXISTS `origen_police_federal` (
`citizenid` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
`time` INT(11) NULL DEFAULT NULL,
`initial` INT(11) NULL DEFAULT NULL,
`name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
`date` TIMESTAMP NULL DEFAULT current_timestamp(),
`danger` VARCHAR(50) NULL DEFAULT 'NP' COLLATE 'utf8mb4_general_ci',
`joinedfrom` VARCHAR(50) NULL DEFAULT 'Mission Row' COLLATE 'utf8mb4_general_ci',
`image` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci'
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
;
CREATE TABLE IF NOT EXISTS `origen_police_notes` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`citizenid` VARCHAR(60) NOT NULL COLLATE 'utf8mb4_general_ci',
`title` VARCHAR(255) NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
`description` TEXT NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
`author` VARCHAR(255) NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
`date` TIMESTAMP NULL DEFAULT current_timestamp(),
`fixed` INT(1) NULL DEFAULT '0',
PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
;
CREATE TABLE IF NOT EXISTS `origen_police_clocks` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`citizenid` VARCHAR(60) NOT NULL COLLATE 'utf8mb4_general_ci',
`name` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_general_ci',
`clockin` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_general_ci',
`clockout` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_general_ci',
`minutes` INT(11) NOT NULL DEFAULT '0',
`job` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_general_ci',
PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
;
CREATE TABLE IF NOT EXISTS `origen_police_reports` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`title` VARCHAR(255) NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
`description` TEXT NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
`author` VARCHAR(255) NOT NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
`cops` TEXT NULL DEFAULT '[]' COLLATE 'utf8mb4_general_ci',
`implicated` TEXT NULL DEFAULT '[]' COLLATE 'utf8mb4_general_ci',
`date` TIMESTAMP NULL DEFAULT current_timestamp(),
`evidences` TEXT NULL DEFAULT '[]' COLLATE 'utf8mb4_general_ci',
`tags` TEXT NULL DEFAULT '["Caso Abierto"]' COLLATE 'utf8mb4_general_ci',
`location` VARCHAR(255) NOT NULL DEFAULT 'Sin ubicacion asignada' COLLATE 'utf8mb4_general_ci',
`victims` MEDIUMTEXT NULL DEFAULT '[]' COLLATE 'utf8mb4_general_ci',
`vehicles` MEDIUMTEXT NULL DEFAULT '[]' COLLATE 'utf8mb4_general_ci',
`job` VARCHAR(50) NULL DEFAULT 'police' COLLATE 'utf8mb4_general_ci',
PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
;
CREATE TABLE IF NOT EXISTS `origen_police_bills` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`citizenid` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_general_ci',
`title` VARCHAR(255) NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
`concepts` TEXT NULL DEFAULT '[]' COLLATE 'utf8mb4_general_ci',
`price` INT(11) NULL DEFAULT '0',
`job` VARCHAR(50) NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
`author` VARCHAR(255) NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
`payed` INT(1) NULL DEFAULT '0',
`date` TIMESTAMP NULL DEFAULT current_timestamp(),
`months` INT(11) NULL DEFAULT '0',
`reportid` INT(11) NULL DEFAULT '0',
PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
;
CREATE TABLE IF NOT EXISTS `origen_police_shapes` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`type` VARCHAR(50) NOT NULL COLLATE 'utf8_general_ci',
`title` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
`data` TEXT NOT NULL COLLATE 'utf8_general_ci',
`radius` FLOAT NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8_general_ci' ENGINE=InnoDB;
CREATE TABLE IF NOT EXISTS `origen_metadata` (
`id` varchar(255) NOT NULL DEFAULT '',
`data` longtext DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
CREATE TABLE IF NOT EXISTS `origen_police_ankle` (
`citizenid` varchar(50) NOT NULL,
`policeOwner` varchar(50) NOT NULL,
`date` timestamp NOT NULL DEFAULT current_timestamp(),
`lastShock` timestamp NULL,
PRIMARY KEY (`citizenid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
CREATE TABLE IF NOT EXISTS `origen_police_alerts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`x` int(11) NOT NULL,
`y` int(11) NOT NULL,
`job` varchar(50) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;Last updated