X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=setup%2Fsqlite2%2Fstats.sql;fp=setup%2Fsqlite2%2Fstats.sql;h=d738dc0d46b8c742a27bc6b54c113d74553235c0;hb=ccc02c22796957aa2f2951c1146d58645261ad0f;hp=0000000000000000000000000000000000000000;hpb=096e9be93be7012b5e81ccd1ec8f779e0b680922;p=infobot.git

diff --git a/setup/sqlite2/stats.sql b/setup/sqlite2/stats.sql
new file mode 100644
index 0000000..d738dc0
--- /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(30) NOT NULL DEFAULT "PRIVATE",
+ time INT UNSIGNED DEFAULT 'UNIX_TIMESTAMP()',
+ counter SMALLINT UNSIGNED DEFAULT '0',
+ PRIMARY KEY (nick,type,channel)
+);