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