¿Te referís a esto?
CREATE TABLE IF NOT EXISTS `pireps` (
`pirep_id` bigint(20) NOT NULL AUTO_INCREMENT,
`from_airport` varchar(4) NOT NULL,
`to_airport` varchar(4) NOT NULL,
`duration` float NOT NULL,
`gvauser_id` int(11) NOT NULL,
`date` date NOT NULL,
`plane_type` varchar(8) NOT NULL,
`fuel` bigint(20) NOT NULL,
`comment` varchar(400) DEFAULT NULL,
`valid` tinyint(4) NOT NULL DEFAULT '0',
`distance` int(11) DEFAULT '0',
`charter` tinyint(4) NOT NULL,
`paid` tinyint(4) NOT NULL DEFAULT '0',
`route` int(11) DEFAULT NULL,
`flight` varchar(10) DEFAULT NULL,
`validator_comments` varchar(500) DEFAULT NULL,
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`rating` int(11) DEFAULT '100',
PRIMARY KEY (`pirep_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9223372036854775808 ;