1CREATE TABLE silo (
2    id NUMBER(10) PRIMARY KEY,
3    src_addr VARCHAR2(255) DEFAULT '',
4    dst_addr VARCHAR2(255) DEFAULT '',
5    username VARCHAR2(64) DEFAULT '',
6    domain VARCHAR2(64) DEFAULT '',
7    inc_time NUMBER(10) DEFAULT 0 NOT NULL,
8    exp_time NUMBER(10) DEFAULT 0 NOT NULL,
9    snd_time NUMBER(10) DEFAULT 0 NOT NULL,
10    ctype VARCHAR2(32) DEFAULT 'text/plain',
11    body BLOB,
12    extra_hdrs CLOB,
13    callid VARCHAR2(128) DEFAULT '',
14    status NUMBER(10) DEFAULT 0 NOT NULL
15);
16
17CREATE OR REPLACE TRIGGER silo_tr
18before insert on silo FOR EACH ROW
19BEGIN
20  auto_id(:NEW.id);
21END silo_tr;
22/
23BEGIN map2users('silo'); END;
24/
25CREATE INDEX silo_account_idx  ON silo (username, domain);
26
27INSERT INTO version (table_name, table_version) values ('silo','8');
28
29