X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=setup%2Fmysql%2Fstats.sql;h=442817f3ce7e8cfd6bf7b63412f7625915d3b2c8;hb=d2f87ccd1d5f93afedc8f9f13b9f35260328614a;hp=d738dc0d46b8c742a27bc6b54c113d74553235c0;hpb=8c02af53f6f6b48e13fcea6462b41a2323435a35;p=infobot.git

diff --git a/setup/mysql/stats.sql b/setup/mysql/stats.sql
index d738dc0..442817f 100644
--- a/setup/mysql/stats.sql
+++ b/setup/mysql/stats.sql
@@ -1,8 +1,12 @@
-CREATE TABLE stats (
- nick VARCHAR(20) NOT NULL,
- type VARCHAR(8) NOT NULL,
- channel VARCHAR(30) 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;