15 lines
455 B
MySQL
15 lines
455 B
MySQL
|
-- $Horde: imp/scripts/sql/imp.sql,v 1.1.2.1 2007/12/20 14:00:36 jan Exp $
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS imp_sentmail (
|
||
|
|
sentmail_id BIGINT NOT NULL,
|
||
|
|
sentmail_who VARCHAR(255) NOT NULL,
|
||
|
|
sentmail_ts BIGINT NOT NULL,
|
||
|
|
sentmail_messageid VARCHAR(255) NOT NULL,
|
||
|
|
sentmail_action VARCHAR(32) NOT NULL,
|
||
|
|
sentmail_recipient VARCHAR(255) NOT NULL,
|
||
|
|
sentmail_success INT NOT NULL,
|
||
|
|
--
|
||
|
|
PRIMARY KEY (sentmail_id)
|
||
|
|
);
|
||
|
|
|