-CREATE TABLE stats (
- nick VARCHAR(20) NOT NULL,
- type VARCHAR(8) NOT NULL,
- channel VARCHAR(16) NOT NULL DEFAULT "PRIVATE",
- time INT UNSIGNED DEFAULT 'UNIX_TIMESTAMP()',
- counter SMALLINT UNSIGNED DEFAULT '0',
- PRIMARY KEY (nick,type,channel)
-);
+--
+-- Table structure for table `stats`
+--
+
+CREATE TABLE `stats` (
+ `nick` varchar(20) NOT NULL default '',
+ `type` varchar(8) NOT NULL default '',
+ `channel` varchar(30) NOT NULL default 'PRIVATE',
+ `time` int(10) unsigned default '0',
+ `counter` smallint(5) unsigned default '0',
+ PRIMARY KEY (`nick`,`type`,`channel`)
+) TYPE=MyISAM;