X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=setup%2Fsqlite%2Fstats.sql;h=d738dc0d46b8c742a27bc6b54c113d74553235c0;hb=de9ba421b308e658a84413cd17ddaedf8fead5a1;hp=97f773c96682d52cd24440c18c5f83cf2dda82b7;hpb=1c0a2202fe58159dd4d4197c4ff8b21f9387685e;p=infobot.git diff --git a/setup/sqlite/stats.sql b/setup/sqlite/stats.sql index 97f773c..d738dc0 100644 --- a/setup/sqlite/stats.sql +++ b/setup/sqlite/stats.sql @@ -1,7 +1,7 @@ CREATE TABLE stats ( nick VARCHAR(20) NOT NULL, type VARCHAR(8) NOT NULL, - channel VARCHAR(16) NOT NULL DEFAULT "PRIVATE", + channel VARCHAR(30) NOT NULL DEFAULT "PRIVATE", time INT UNSIGNED DEFAULT 'UNIX_TIMESTAMP()', counter SMALLINT UNSIGNED DEFAULT '0', PRIMARY KEY (nick,type,channel)