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