DROP TABLE IF EXISTS `dispatch_callsigns`;
CREATE TABLE IF NOT EXISTS `dispatch_callsigns` (
`identifier` varchar(46) NOT NULL,
`callsign` varchar(50) NOT NULL,
PRIMARY KEY (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
DROP TABLE IF EXISTS `dispatch_cameras`;
CREATE TABLE IF NOT EXISTS `dispatch_cameras` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(25) DEFAULT NULL,
`model` varchar(50) NOT NULL,
`coords` varchar(255) NOT NULL,
`type` varchar(50) DEFAULT NULL,
`metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
DROP TABLE IF EXISTS `dispatch_jail_database`;
CREATE TABLE IF NOT EXISTS `dispatch_jail_database` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`player_identifier` varchar(255) NOT NULL,
`jail_reason` varchar(255) NOT NULL,
`jail_time` int(11) NOT NULL,
`jail_start` timestamp NOT NULL DEFAULT current_timestamp(),
`jail_end` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
DROP TABLE IF EXISTS `dispatch_mdt_bolos`;
CREATE TABLE IF NOT EXISTS `dispatch_mdt_bolos` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`CreatorName` varchar(50) DEFAULT NULL,
`jobtype` varchar(25) DEFAULT 'police',
`title` varchar(50) DEFAULT NULL,
`content` mediumtext DEFAULT NULL,
`officers_involved` text DEFAULT NULL,
`createdAt` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
DROP TABLE IF EXISTS `dispatch_mdt_convictions`;
CREATE TABLE IF NOT EXISTS `dispatch_mdt_convictions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`identifier` varchar(46) DEFAULT NULL,
`charges` text DEFAULT NULL,
`warrant` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
DROP TABLE IF EXISTS `dispatch_mdt_data`;
CREATE TABLE IF NOT EXISTS `dispatch_mdt_data` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`identifier` varchar(46) DEFAULT NULL,
`tags` text NOT NULL,
`jobtype` varchar(25) DEFAULT 'police',
`pfp` text DEFAULT NULL,
`notes` mediumtext DEFAULT NULL,
KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
DROP TABLE IF EXISTS `dispatch_mdt_incidents`;
CREATE TABLE IF NOT EXISTS `dispatch_mdt_incidents` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`CreatorName` varchar(50) DEFAULT NULL,
`jobtype` varchar(25) DEFAULT 'police',
`title` varchar(50) DEFAULT NULL,
`content` mediumtext DEFAULT NULL,
`citizens_involved` text DEFAULT NULL,
`criminals_involved` text DEFAULT NULL,
`officers_involved` text DEFAULT NULL,
`createdAt` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
DROP TABLE IF EXISTS `dispatch_players_database`;
CREATE TABLE IF NOT EXISTS `dispatch_players_database` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`identifier` longtext NOT NULL,
`datatype` varchar(1200) NOT NULL DEFAULT 'undefinedData',
`dataobj` longtext NOT NULL,
`createdAt` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
DROP TABLE IF EXISTS `dispatch_vehicle_database`;
CREATE TABLE IF NOT EXISTS `dispatch_vehicle_database` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`datatype` varchar(50) DEFAULT NULL,
`by` varchar(50) DEFAULT NULL,
`plate` varchar(50) NOT NULL,
`data` longtext DEFAULT NULL,
`createdAt` varchar(150) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
DROP TABLE IF EXISTS `dispatch_callsigns`;
CREATE TABLE IF NOT EXISTS `dispatch_callsigns` (
`identifier` varchar(46) NOT NULL,
`callsign` varchar(50) NOT NULL,
PRIMARY KEY (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
DROP TABLE IF EXISTS `dispatch_cameras`;
CREATE TABLE IF NOT EXISTS `dispatch_cameras` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(25) DEFAULT NULL,
`model` varchar(50) NOT NULL,
`coords` varchar(255) NOT NULL,
`type` varchar(50) DEFAULT NULL,
`metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
DROP TABLE IF EXISTS `dispatch_jail_database`;
CREATE TABLE IF NOT EXISTS `dispatch_jail_database` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`player_identifier` varchar(255) NOT NULL,
`jail_reason` varchar(255) NOT NULL,
`jail_time` int(11) NOT NULL,
`jail_start` timestamp NOT NULL DEFAULT current_timestamp(),
`jail_end` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
DROP TABLE IF EXISTS `dispatch_mdt_bolos`;
CREATE TABLE IF NOT EXISTS `dispatch_mdt_bolos` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`CreatorName` varchar(50) DEFAULT NULL,
`jobtype` varchar(25) DEFAULT 'police',
`title` varchar(50) DEFAULT NULL,
`content` mediumtext DEFAULT NULL,
`officers_involved` text DEFAULT NULL,
`createdAt` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
DROP TABLE IF EXISTS `dispatch_mdt_convictions`;
CREATE TABLE IF NOT EXISTS `dispatch_mdt_convictions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`identifier` varchar(46) DEFAULT NULL,
`charges` text DEFAULT NULL,
`warrant` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
DROP TABLE IF EXISTS `dispatch_mdt_data`;
CREATE TABLE IF NOT EXISTS `dispatch_mdt_data` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`identifier` varchar(46) DEFAULT NULL,
`tags` text NOT NULL,
`jobtype` varchar(25) DEFAULT 'police',
`pfp` text DEFAULT NULL,
`notes` mediumtext DEFAULT NULL,
KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
DROP TABLE IF EXISTS `dispatch_mdt_incidents`;
CREATE TABLE IF NOT EXISTS `dispatch_mdt_incidents` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`CreatorName` varchar(50) DEFAULT NULL,
`jobtype` varchar(25) DEFAULT 'police',
`title` varchar(50) DEFAULT NULL,
`content` mediumtext DEFAULT NULL,
`citizens_involved` text DEFAULT NULL,
`criminals_involved` text DEFAULT NULL,
`officers_involved` text DEFAULT NULL,
`createdAt` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
DROP TABLE IF EXISTS `dispatch_players_database`;
CREATE TABLE IF NOT EXISTS `dispatch_players_database` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`identifier` longtext NOT NULL,
`datatype` varchar(1200) NOT NULL DEFAULT 'undefinedData',
`dataobj` longtext NOT NULL,
`createdAt` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
DROP TABLE IF EXISTS `dispatch_vehicle_database`;
CREATE TABLE IF NOT EXISTS `dispatch_vehicle_database` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`datatype` varchar(50) DEFAULT NULL,
`by` varchar(50) DEFAULT NULL,
`plate` varchar(50) NOT NULL,
`data` longtext DEFAULT NULL,
`createdAt` varchar(150) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;