SHARE
TWEET

User Event Counter Table Structure

a guest Sep 16th, 2016 38 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE 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=0 DEFAULT CHARSET=latin1;
  8.  
  9. ALTER TABLE `<TABLENAMEHERE>`
  10.  ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `uniqueCombo` (`type`,`ts3dbid`,`ts3uid`);
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top