USE `utilities`;
CREATE TABLE `detail_usage` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `app` varchar(50) NOT NULL,
  `i1` varchar(50) NOT NULL,
  `i2` varchar(50) NULL,
  `i3` varchar(50) NULL,
  `date_logged` date NOT NULL,
  PRIMARY KEY (`id`),
  KEY `app` (`app`),
  KEY `i1` (`i1`),
  KEY `i2` (`i2`),
  KEY `i3` (`i3`),
  KEY `date_logged` (`date_logged`)
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8;
