`id` int(11) NOT NULL AUTO_INCREMENT,
              `steamid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
              `userName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
              `sourceCompany` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
              `sourceCity` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
              `destinationCompany` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
              `destinationCity` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
              `startOdometer` float(20,2) NOT NULL DEFAULT '0.00',
              `truckOdometer` float(20,2) NOT NULL DEFAULT '0.00',
              `endOdometer` float(20,2) DEFAULT '0.00',
              `distanceDriven` float(20,2) DEFAULT '0.00',
              `litresBurned` float(20,2) DEFAULT '0.00',
              `litresPurchased` float(20,2) NOT NULL DEFAULT '0.00',
              `trailerName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
              `trailerMass` float(20,2) DEFAULT '0.00',
              `startDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
              `lastUpdateDate` timestamp NULL DEFAULT NULL,
              `litresRemaining` FLOAT( 6, 2 ) NOT NULL DEFAULT '0.00',
              `submitDate` timestamp NULL DEFAULT NULL,
              `income` mediumint(7) DEFAULT '0',
              `wasSpeeding` tinyint(1) NOT NULL DEFAULT '0',
              `topSpeed` float(11,6) NOT NULL DEFAULT '0.000000',
              `fuelCost` float(20,2) NOT NULL DEFAULT '0.00',
              `fuelFactor` float(20,2) NOT NULL DEFAULT '0.00',
              `ferryCost` int(10) NOT NULL DEFAULT '0',
              `trainCost` int(10) NOT NULL DEFAULT '0',
              `trailerDamageCost` float(7,2) NOT NULL DEFAULT '0',
              `engineDamage` float(20,2) NOT NULL DEFAULT '0',
              `transmissionDamage` float(20,2) NOT NULL DEFAULT '0',
              `chassisDamage` float(20,2) NOT NULL DEFAULT '0',
              `cabinDamage` float(20,2) NOT NULL DEFAULT '0',
              `wheelDamage` float(20,2) NOT NULL DEFAULT '0',
              `trailerDamage` float(20,2) NOT NULL DEFAULT '0',
              `travelExpenses` float(20,2) NOT NULL DEFAULT '0.00',
              `ferriesTaken` varchar(5000) COLLATE utf8_unicode_ci NOT NULL DEFAULT '[]',
              `trainsTaken` varchar(5000) COLLATE utf8_unicode_ci NOT NULL DEFAULT '[]',
              `wasLate` tinyint(1) NOT NULL DEFAULT '0',
              `game` varchar(255) CHARACTER SET latin1 NOT NULL,
              `fuelType` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT 'Litres',
              `distanceType` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT 'KM',
              `weightType` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT 'Tonnes',
              `currency` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT 'EUR',
              `truckModel` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
              `truckMake` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
              `status` varchar(24) CHARACTER SET latin1 NOT NULL DEFAULT 'Unknown',
              `approved` tinyint(1) NOT NULL DEFAULT '0',
              `comments` varchar(5000) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
              `loggerVersion` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT '1.0.0.15',
              `vtcCode` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT :vtcCode,
              `vtcName` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT :vtcName,
              `startX` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT :zero,
              `startY` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT :zero,
              `startZ` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT :zero,
              `endX` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT :zero,
              `endZ` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT :zero,
              `endY` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT :zero,
              PRIMARY KEY (`id`)
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;