NWpBMZAT

1Is this a good way of collecting click events?
2CREATE TABLE IF NOT EXISTS `stattableindexed` (
3  `id` int(10) unsigned NOT NULL auto_increment,
4  `lid` int(10) unsigned NOT NULL COMMENT 'Listing ID',
5  `serviceareaid` int(10) unsigned NOT NULL COMMENT 'Service Area ID',
6  `domainid` int(10) unsigned NOT NULL COMMENT 'Domain ID',
7  `bizgroup` int(10) unsigned NOT NULL COMMENT 'Business Group',
8  `eventid` int(10) unsigned NOT NULL COMMENT 'Event ID',
9  `eventtype` int(10) unsigned NOT NULL COMMENT 'Event Type',
10  `count` int(10) unsigned NOT NULL COMMENT 'Count of Events',
11  `timeunitid` bigint(10) unsigned NOT NULL COMMENT 'Time units',
12  PRIMARY KEY  (`id`),
13  KEY `timeunitid` (`timeunitid`),
14  KEY `lid` (`lid`),
15  KEY `serviceareaid` (`serviceareaid`),
16  KEY `domainid` (`domainid`),
17  KEY `bizgroup` (`bizgroup`),
18  KEY `eventid` (`eventid`),
19  KEY `eventtype` (`eventtype`),
20  KEY `count` (`count`)
21) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;