1CREATE TABLE silo (
2    id SERIAL PRIMARY KEY NOT NULL,
3    src_addr VARCHAR(255) DEFAULT '' NOT NULL,
4    dst_addr VARCHAR(255) DEFAULT '' NOT NULL,
5    username VARCHAR(64) DEFAULT '' NOT NULL,
6    domain VARCHAR(64) DEFAULT '' NOT NULL,
7    inc_time INTEGER DEFAULT 0 NOT NULL,
8    exp_time INTEGER DEFAULT 0 NOT NULL,
9    snd_time INTEGER DEFAULT 0 NOT NULL,
10    ctype VARCHAR(32) DEFAULT 'text/plain' NOT NULL,
11    body BYTEA,
12    extra_hdrs TEXT,
13    callid VARCHAR(128) DEFAULT '' NOT NULL,
14    status INTEGER DEFAULT 0 NOT NULL
15);
16
17CREATE INDEX silo_account_idx ON silo (username, domain);
18
19INSERT INTO version (table_name, table_version) values ('silo','8');
20
21