kamailio/utils/kamctl/oracle/purple-create.sql

CREATE TABLE purplemap (
    id NUMBER(10) PRIMARY KEY,
    sip_user VARCHAR2(128),
    ext_user VARCHAR2(128),
    ext_prot VARCHAR2(16),
    ext_pass VARCHAR2(64)
);

CREATE OR REPLACE TRIGGER purplemap_tr
before insert on purplemap FOR EACH ROW
BEGIN
  auto_id(:NEW.id);
END purplemap_tr;
/
BEGIN map2users('purplemap'); END;
/
INSERT INTO version (table_name, table_version) values ('purplemap','1');