major re-organisation of the different SQL files; cleanup and fixing of the postgres...

[infobot.git] / setup / stats.sql

diff --git a/setup/stats.sql b/setup/stats.sql
index d1b7b2f88101033e747ec3a040eb1317d83ccf63..97f773c96682d52cd24440c18c5f83cf2dda82b7 100644 (file)
--- a/setup/stats.sql
+++ b/setup/stats.sql
@@ -1,8 +1,8 @@
 CREATE TABLE stats (
-       nick VARCHAR(20) NOT NULL,
-       type VARCHAR(8) NOT NULL,
-
-       counter SMALLINT UNSIGNED DEFAULT '0',
-
-       PRIMARY KEY (nick,type)
+ 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)
 );