X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=setup%2Fstats.sql;h=4a585b1501200a67479efb6e1581e7097ef2c798;hb=c68ac9b2d4b88535c1a2cfa695f6c4f683f0373c;hp=d1b7b2f88101033e747ec3a040eb1317d83ccf63;hpb=3d90aae6dc5fadecb17f85531b1222472a8f520a;p=infobot.git

diff --git a/setup/stats.sql b/setup/stats.sql
index d1b7b2f..4a585b1 100644
--- 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)
 );