avoid reassigning to temp upon decode_utf8

[infobot.git] / setup / sqlite / botmail.sql

CREATE TABLE botmail (
 srcwho VARCHAR(20) NOT NULL,
 dstwho VARCHAR(20) NOT NULL,
 srcuh VARCHAR(80) NOT NULL,
 time INT UNSIGNED DEFAULT 'UNIX_TIMESTAMP()',
 msg TEXT NOT NULL,
 PRIMARY KEY (srcwho,dstwho)
);