pzKEwyf7

1-- Adminer 4.7.6 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `pm8jxs_departments`;
9CREATE TABLE `pm8jxs_departments` (
10  `departmentId` int(11) NOT NULL,
11  `departmentName` varchar(255) DEFAULT NULL COMMENT 'The functional name of the department. (eg. Police, Fire, EMS)',
12  `departmentShortName` varchar(10) NOT NULL COMMENT 'The acronym of the department name. (eg. BCSO, LAPD, LAFD)',
13  `departmentLongName` varchar(255) NOT NULL COMMENT 'The name of the department. (eg. Los Angeles Police Department, Blaine County Sheriffs` Office)',
14  `departmentEnabled` int(1) DEFAULT 2 COMMENT 'If 1 then department is disabled, if 2 then department is enabled.'
15) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
16
17INSERT INTO `pm8jxs_departments` (`departmentId`, `departmentName`, `departmentShortName`, `departmentLongName`, `departmentEnabled`) VALUES
18(1,	'Communications',	'SAECOMM',	'San Andreas Emergency Communications',	0),
19(2,	'State',	'SASP',	'San Andreas State Police',	0),
20(3,	'Highway',	'SAHP',	'San Andreas Highway Patrol',	0),
21(4,	'Sheriff',	'BCSO',	'Blaine County Sheriffs\' Office',	0),
22(5,	'Police',	'SAPD',	'San Andreas Police Department',	0),
23(6,	'Fire',	'SAFD',	'San Andreas Fire Department',	0),
24(7,	'EMS',	'SAEMS',	'San Andreas Emergency Services',	0),
25(8,	'Civilian',	'SACS',	'San Andreas Civilian Services',	0),
26(9,	'Roadside Assistance',	'SARA',	'San Andreas Roadside Assistance',	0);
27
28DROP TABLE IF EXISTS `pm8jxs_userdepartments`;
29CREATE TABLE `pm8jxs_userdepartments` (
30  `userId` int(11) NOT NULL,
31  `departmentId` int(11) NOT NULL
32) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
33
34INSERT INTO `pm8jxs_userdepartments` (`userId`, `departmentId`) VALUES
35(2,	1),
36(2,	3),
37(2,	9),
38(1,	1),
39(1,	2),
40(1,	3),
41(1,	4),
42(1,	5),
43(1,	6),
44(1,	7),
45(1,	8),
46(1,	9);
47
48-- 2020-03-20 23:39:39