CREATE TABLE `owned_vehicles` (
`owner` VARCHAR(22) NOT NULL COLLATE 'utf8mb4_bin',
`plate` VARCHAR(12) NOT NULL COLLATE 'utf8mb4_bin',
`vehicle` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
`type` VARCHAR(20) NOT NULL DEFAULT 'car' COLLATE 'utf8mb4_bin',
`job` VARCHAR(20) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
`state` VARCHAR(20) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
`stored` TINYINT(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`plate`) USING BTREE
)
COLLATE='utf8mb4_bin'
ENGINE=InnoDB
;