From f7637adb4b4826a76204df80a920409e5bb8a69b Mon Sep 17 00:00:00 2001 From: dms Date: Fri, 18 May 2001 15:21:20 +0000 Subject: [PATCH] - new, removed, modified files git-svn-id: https://svn.code.sf.net/p/infobot/code/trunk/blootbot@492 c11ca15a-4712-0410-83d8-924469b57eb5 --- setup/karma.sql | 6 ------ setup/seen.sql | 2 -- setup/stats.sql | 8 ++++++++ 3 files changed, 8 insertions(+), 8 deletions(-) delete mode 100644 setup/karma.sql create mode 100644 setup/stats.sql diff --git a/setup/karma.sql b/setup/karma.sql deleted file mode 100644 index 21c5db7..0000000 --- a/setup/karma.sql +++ /dev/null @@ -1,6 +0,0 @@ -CREATE TABLE karma ( - nick VARCHAR(20) NOT NULL, - karma SMALLINT, - - PRIMARY KEY (nick) -); diff --git a/setup/seen.sql b/setup/seen.sql index 2672ba6..20b4966 100644 --- a/setup/seen.sql +++ b/setup/seen.sql @@ -3,8 +3,6 @@ CREATE TABLE seen ( time INT NOT NULL, channel VARCHAR(20) NOT NULL, host VARCHAR(80) NOT NULL, - messagecount SMALLINT UNSIGNED, - hehcount SMALLINT UNSIGNED, message TINYTEXT NOT NULL, PRIMARY KEY (nick) diff --git a/setup/stats.sql b/setup/stats.sql new file mode 100644 index 0000000..d1b7b2f --- /dev/null +++ b/setup/stats.sql @@ -0,0 +1,8 @@ +CREATE TABLE stats ( + nick VARCHAR(20) NOT NULL, + type VARCHAR(8) NOT NULL, + + counter SMALLINT UNSIGNED DEFAULT '0', + + PRIMARY KEY (nick,type) +); -- 2.39.5