/usr/share/opensips/postgres/dialog-create.sql is in opensips-postgres-module 2.2.2-3build4.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 | INSERT INTO version (table_name, table_version) values ('dialog','10');
CREATE TABLE dialog (
dlg_id BIGINT PRIMARY KEY NOT NULL,
callid VARCHAR(255) NOT NULL,
from_uri VARCHAR(128) NOT NULL,
from_tag VARCHAR(64) NOT NULL,
to_uri VARCHAR(128) NOT NULL,
to_tag VARCHAR(64) NOT NULL,
mangled_from_uri VARCHAR(64) DEFAULT NULL,
mangled_to_uri VARCHAR(64) DEFAULT NULL,
caller_cseq VARCHAR(11) NOT NULL,
callee_cseq VARCHAR(11) NOT NULL,
caller_ping_cseq INTEGER NOT NULL,
callee_ping_cseq INTEGER NOT NULL,
caller_route_set TEXT,
callee_route_set TEXT,
caller_contact VARCHAR(128),
callee_contact VARCHAR(128),
caller_sock VARCHAR(64) NOT NULL,
callee_sock VARCHAR(64) NOT NULL,
state INTEGER NOT NULL,
start_time INTEGER NOT NULL,
timeout INTEGER NOT NULL,
vars BYTEA DEFAULT NULL,
profiles TEXT DEFAULT NULL,
script_flags INTEGER DEFAULT 0 NOT NULL,
module_flags INTEGER DEFAULT 0 NOT NULL,
flags INTEGER DEFAULT 0 NOT NULL
);
|