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