- patch from Morten Brix Pedersen <morten@wtf.dk>. Thanks!

[infobot.git] / setup / stats.sql

diff --git a/setup/stats.sql b/setup/stats.sql
index d1b7b2f88101033e747ec3a040eb1317d83ccf63..4a585b1501200a67479efb6e1581e7097ef2c798 100644 (file)
--- a/setup/stats.sql
+++ b/setup/stats.sql
@@ -1,8 +1,10 @@
 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)
+       PRIMARY KEY (nick,type,channel)
 );