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

INSERT INTO version (table_name, table_version) values ('dispatcher','4');
CREATE TABLE dispatcher (
    id NUMBER(10) PRIMARY KEY,
    setid NUMBER(10) DEFAULT 0 NOT NULL,
    destination VARCHAR2(192) DEFAULT '',
    flags NUMBER(10) DEFAULT 0 NOT NULL,
    priority NUMBER(10) DEFAULT 0 NOT NULL,
    attrs VARCHAR2(128) DEFAULT '',
    description VARCHAR2(64) DEFAULT ''
);

CREATE OR REPLACE TRIGGER dispatcher_tr
before insert on dispatcher FOR EACH ROW
BEGIN
  auto_id(:NEW.id);
END dispatcher_tr;
/
BEGIN map2users('dispatcher'); END;
/