SQL

Database table

CREATE TABLE IF NOT EXISTS `org_parking` (
  `id`         VARCHAR(12)  NOT NULL,
  `owner`      VARCHAR(60)  NOT NULL DEFAULT '',
  `parkedBy`   VARCHAR(60)  NOT NULL DEFAULT '',
  `plate`      VARCHAR(12)  NOT NULL DEFAULT '',
  `model`      VARCHAR(64)  NOT NULL DEFAULT '',
  `hash`       BIGINT       NOT NULL DEFAULT 0,
  `coords`     LONGTEXT     NOT NULL,
  `dimension`  INT          NOT NULL DEFAULT 0,
  `type`       VARCHAR(32)  NOT NULL DEFAULT 'automobile',
  `mods`       LONGTEXT     NOT NULL,
  `lastUpdate` DATETIME     NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  INDEX `idx_owner`  (`owner`),
  INDEX `idx_plate`  (`plate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

If you are using the legacy version of the parking system, you must migrate the tables to include the new data.

Migration step (OPTIONAL)

-- Copy data from old table (change source table name if needed):
INSERT IGNORE INTO `org_parking`
  SELECT `id`, `owner`, `parkedBy`, `plate`, `model`, `hash`,
         `coords`, `dimension`, `type`, `mods`, `lastUpdate`
  FROM `origen_parking`;

-- Verify the migration, then drop the old table if everything looks good:
-- DROP TABLE IF EXISTS `origen_parking`;