CREATE TABLE IF NOT EXISTS `tgiann_realparking` (
  `citizenid` varchar(50) DEFAULT NULL,
  `plate` varchar(50) DEFAULT NULL,
  `properties` longtext DEFAULT NULL,
  `garage` varchar(50) DEFAULT NULL,
  `slot` int(11) DEFAULT NULL,
  `coords` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE IF NOT EXISTS `tgiann_realparking_impound` (
  `plate` varchar(50) DEFAULT NULL,
  `impound` longtext DEFAULT NULL,
  `minute` int(11) DEFAULT NULL,
  `finishUnixTime` int(11) DEFAULT NULL,
  `money` int(11) DEFAULT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE IF NOT EXISTS `tgiann_realparking_insurance` (
  `plate` varchar(50) DEFAULT NULL,
  `insurance` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
