User Event Counter Table Structure

CREATE TABLE IF NOT EXISTS `<TABLENAMEHERE>` (
`id` int(16) NOT NULL,
  `type` int(4) DEFAULT NULL COMMENT '0 - connection lost, 1 - got kicked, 2 - got banned, 3 - has kicked, 4 - has banned',
  `ts3dbid` int(16) DEFAULT NULL,
  `ts3uid` varchar(64) DEFAULT NULL,
  `counter` int(16) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;

ALTER TABLE `<TABLENAMEHERE>`
 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `uniqueCombo` (`type`,`ts3dbid`,`ts3uid`);