/usr/share/opensips/mysql/dialog-create.sql is in opensips-mysql-module 2.2.2-3.
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(10) UNSIGNED PRIMARY KEY NOT NULL,
callid CHAR(255) NOT NULL,
from_uri CHAR(128) NOT NULL,
from_tag CHAR(64) NOT NULL,
to_uri CHAR(128) NOT NULL,
to_tag CHAR(64) NOT NULL,
mangled_from_uri CHAR(64) DEFAULT NULL,
mangled_to_uri CHAR(64) DEFAULT NULL,
caller_cseq CHAR(11) NOT NULL,
callee_cseq CHAR(11) NOT NULL,
caller_ping_cseq INT(11) UNSIGNED NOT NULL,
callee_ping_cseq INT(11) UNSIGNED NOT NULL,
caller_route_set TEXT(512),
callee_route_set TEXT(512),
caller_contact CHAR(128),
callee_contact CHAR(128),
caller_sock CHAR(64) NOT NULL,
callee_sock CHAR(64) NOT NULL,
state INT(10) UNSIGNED NOT NULL,
start_time INT(10) UNSIGNED NOT NULL,
timeout INT(10) UNSIGNED NOT NULL,
vars BLOB(4096) DEFAULT NULL,
profiles TEXT(512) DEFAULT NULL,
script_flags INT(10) UNSIGNED DEFAULT 0 NOT NULL,
module_flags INT(10) UNSIGNED DEFAULT 0 NOT NULL,
flags INT(10) UNSIGNED DEFAULT 0 NOT NULL
) ENGINE=InnoDB;
|