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

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

diff --git a/setup/sqlite2/stats.sql b/setup/sqlite2/stats.sql
new file mode 100644 (file)
index 0000000..97f773c
--- /dev/null
+++ b/setup/sqlite2/stats.sql
@@ -0,0 +1,8 @@
+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,channel)
+);