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