* Missed DebianBugs.pl in the previous merge

[infobot.git] / setup / mysql / stats.sql

diff --git a/setup/mysql/stats.sql b/setup/mysql/stats.sql
index d738dc0d46b8c742a27bc6b54c113d74553235c0..442817f3ce7e8cfd6bf7b63412f7625915d3b2c8 100644 (file)
--- 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;