ヤミRoot VoidGate

Viewing: pgsql.sql

CREATE TABLE mail_queue (
id INT NOT NULL default 0 PRIMARY KEY,
create_time timestamp NOT NULL default '1970-01-01 00:00:00',
time_to_send timestamp NOT NULL default '1970-01-01 00:00:00',
sent_time timestamp default NULL,
id_user INT NOT NULL default 0,
ip varchar(20) NOT NULL default 'unknown',
sender varchar(50) NOT NULL default '',
recipient text NOT NULL,
headers text,
body text,
try_sent INT NOT NULL default 0,
delete_after_send INT NOT NULL default 1
);

CREATE INDEX mailq_time_to_send ON mail_queue (time_to_send);
CREATE INDEX mailq_id_user ON mail_queue (id_user);

User / IP	: 216.73.216.110
Host / Server	: 146.88.233.70 / dev.loger.cm
System	: Linux hybrid1120.fr.ns.planethoster.net 3.10.0-957.21.2.el7.x86_64 #1 SMP Wed Jun 5 14:26:44 UTC 2019 x86_64