CREATE TABLE `jails` (
  `dbID` int(11) NOT NULL,
  `jailType` tinyint(4) NOT NULL DEFAULT 1,
  `adminAccountId` int(11) NOT NULL DEFAULT 0,
  `adminName` varchar(255) NOT NULL DEFAULT 'Ismeretlen',
  `jailTime` int(11) NOT NULL DEFAULT 0,
  `accountIdentity` int(11) NOT NULL,
  `jailReason` varchar(255) NOT NULL DEFAULT 'Nincs megadva',
  `jailDuration` int(11) NOT NULL DEFAULT 0,
  `inActive` tinyint(1) NOT NULL DEFAULT 0,
  `jailCell` int(11) NOT NULL DEFAULT 0,
  `jailFine` int(11) NOT NULL DEFAULT 0,
  `jailBail` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- A tábla adatainak kiíratása `jails`
--

INSERT INTO `jails` (`dbID`, `jailType`, `adminAccountId`, `adminName`, `jailTime`, `accountIdentity`, `jailReason`, `jailDuration`, `inActive`, `jailCell`, `jailFine`, `jailBail`) VALUES
(1, 1, 4, 'Zsebee', 1755904509, 4, 'anyád', 31, 0, 0, 0, 0);

-- --------------------------------------------------------

--
-- Tábla szerkezet ehhez a táblához `licenses`
--

CREATE TABLE `licenses` (
  `dbID` int(11) NOT NULL,
  `licenseType` varchar(10) NOT NULL,
  `id` varchar(10) NOT NULL,
  `created` int(11) NOT NULL,
  `expire` int(11) NOT NULL,
  `photo` longblob NOT NULL,
  `name` varchar(255) NOT NULL,
  `revoked` int(11) NOT NULL DEFAULT 0,
  `charId` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- A tábla adatainak kiíratása `licenses`
--

INSERT INTO `licenses` (`dbID`, `licenseType`, `id`, `created`, `expire`, `photo`, `name`, `revoked`, `charId`) VALUES
(24, 'mine', '189211JS', 20279, 20310, 0x[encoded data, 27622 characters], 'Frank Barella', 0, 2);
INSERT INTO `licenses` (`dbID`, `licenseType`, `id`, `created`, `expire`, `photo`, `name`, `revoked`, `charId`) VALUES
(25, 'id', '440394PE', 20279, 20310, 0x[encoded data, 27790 characters], 'Frank Barella', 0, 2),
(27, 'mine', '905761TD', 20279, 20310, 0x[encoded data, 17494 characters], 'Noffy Molinero', 0, 3);
INSERT INTO `licenses` (`dbID`, `licenseType`, `id`, `created`, `expire`, `photo`, `name`, `revoked`, `charId`) VALUES
(28, 'mine', '760271KM', 20280, 20311, 0x[encoded data, 18222 characters], 'Noffy Molinero', 0, 3),
(29, 'mine', '952482VU', 20280, 20311, 0x[encoded data, 15506 characters], 'Khalifa Nassim Ayoub', 0, 21);
INSERT INTO `licenses` (`dbID`, `licenseType`, `id`, `created`, `expire`, `photo`, `name`, `revoked`, `charId`) VALUES
(30, 'dl', '793038VG', 20280, 20311, 0x[encoded data, 18516 characters], 'Noffy Molinero', 0, 3),
(31, 'id', '576793BG', 20280, 20311, 0x[encoded data, 18702 characters], 'Noffy Molinero', 0, 3);
INSERT INTO `licenses` (`dbID`, `licenseType`, `id`, `created`, `expire`, `photo`, `name`, `revoked`, `charId`) VALUES
(32, 'fs', '246232HW', 20280, 20311, 0x[encoded data, 18620 characters], 'Noffy Molinero', 0, 3),
(33, 'wp', '295205ZR', 20280, 20311, 0x[encoded data, 18530 characters], 'Noffy Molinero', 1, 3);
INSERT INTO `licenses` (`dbID`, `licenseType`, `id`, `created`, `expire`, `photo`, `name`, `revoked`, `charId`) VALUES
(34, 'dl', '642686TZ', 20281, 20312, 0x[encoded data, 25602 characters], 'Kalányos Dezső', 0, 1),
(35, 'mine', '143919UH', 20282, 20313, 0x[encoded data, 20438 characters], 'Kalányos Dezső', 0, 1);
INSERT INTO `licenses` (`dbID`, `licenseType`, `id`, `created`, `expire`, `photo`, `name`, `revoked`, `charId`) VALUES
(36, 'mine', '760271KM', 20282, 20313, 0x[encoded data, 17390 characters], 'Noffy Molinero', 0, 3),
(37, 'id', '145155SF', 20284, 20315, 0x[encoded data, 20470 characters], 'Darnell Jayceon', 0, 17);
INSERT INTO `licenses` (`dbID`, `licenseType`, `id`, `created`, `expire`, `photo`, `name`, `revoked`, `charId`) VALUES
(38, 'mine', '981048QS', 20284, 20315, 0x[encoded data, 20652 characters], 'Darnell Jayceon', 0, 17),
(39, 'wp', '258894YT', 20284, 20315, 0x[encoded data, 20126 characters], 'Darnell Jayceon', 1, 17);
INSERT INTO `licenses` (`dbID`, `licenseType`, `id`, `created`, `expire`, `photo`, `name`, `revoked`, `charId`) VALUES
(40, 'id', '352693XV', 20285, 20316, 0x[encoded data, 21400 characters], 'Matthew Oakwood', 0, 26);
INSERT INTO `licenses` (`dbID`, `licenseType`, `id`, `created`, `expire`, `photo`, `name`, `revoked`, `charId`) VALUES
(42, 'id', '147187MS', 20287, 20318, 0x[encoded data, 28882 characters], 'Felkaru Rablo', 0, 25);
INSERT INTO `licenses` (`dbID`, `licenseType`, `id`, `created`, `expire`, `photo`, `name`, `revoked`, `charId`) VALUES
(43, 'wp', '371782VC', 20287, 20318, 0x[encoded data, 28962 characters], 'Felkaru Rablo', 1, 25),
(44, 'wp', '789550UC', 20288, 20319, 0x[encoded data, 17882 characters], 'Ferdinando Barone', 1, 2);
