CREATE TABLE IF NOT EXISTS `reporting_format` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` int(10) unsigned NOT NULL,
  `event_time_threshold` int(11) DEFAULT NULL COMMENT 'In seconds, the threshold stores should aim to keep their service times below',
  `weighted_results` tinyint(4) DEFAULT NULL COMMENT 'True if the customer''s events are to be ranked usinng a weighted calculation. Otherwise figures are used directly.',
  `total_cars_weight` int(11) DEFAULT NULL,
  `percentage_weight` int(11) DEFAULT NULL,
  `total_time_weight` int(11) DEFAULT NULL,
  `total_cars_figure` int(11) DEFAULT NULL,
  `percentage_figure` int(11) DEFAULT NULL,
  `total_time_figure` int(11) DEFAULT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
