git-svn-id: https://svn.code.sf.net/p/infobot/code/trunk/blootbot@492
c11ca15a-4712-0410-83d8-
924469b57eb5
+++ /dev/null
-CREATE TABLE karma (
- nick VARCHAR(20) NOT NULL,
- karma SMALLINT,
-
- PRIMARY KEY (nick)
-);
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)
--- /dev/null
+CREATE TABLE stats (
+ nick VARCHAR(20) NOT NULL,
+ type VARCHAR(8) NOT NULL,
+
+ counter SMALLINT UNSIGNED DEFAULT '0',
+
+ PRIMARY KEY (nick,type)
+);