· 10 years ago · Sep 16, 2016, 11:54 AM
1CREATE TABLE IF NOT EXISTS `<TABLENAMEHERE>` (
2`id` int(16) NOT NULL,
3 `type` int(4) DEFAULT NULL COMMENT '0 - connection lost, 1 - got kicked, 2 - got banned, 3 - has kicked, 4 - has banned',
4 `ts3dbid` int(16) DEFAULT NULL,
5 `ts3uid` varchar(64) DEFAULT NULL,
6 `counter` int(16) DEFAULT NULL
7) ENGINE=InnoDB AUTO_INCREMENT=13109 DEFAULT CHARSET=latin1;
8
9ALTER TABLE `<TABLENAMEHERE>`
10 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `uniqueCombo` (`type`,`ts3dbid`,`ts3uid`);