/usr/share/opensips/mysql/b2b-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 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 | INSERT INTO version (table_name, table_version) values ('b2b_entities','1');
CREATE TABLE b2b_entities (
id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
type INT(2) NOT NULL,
state INT(2) NOT NULL,
ruri CHAR(128),
from_uri CHAR(128) NOT NULL,
to_uri CHAR(128) NOT NULL,
from_dname CHAR(64),
to_dname CHAR(64),
tag0 CHAR(64) NOT NULL,
tag1 CHAR(64),
callid CHAR(64) NOT NULL,
cseq0 INT(11) NOT NULL,
cseq1 INT(11),
contact0 CHAR(128) NOT NULL,
contact1 CHAR(128),
route0 TEXT,
route1 TEXT,
sockinfo_srv CHAR(64),
param CHAR(128) NOT NULL,
lm INT(11) NOT NULL,
lrc INT(11),
lic INT(11),
leg_cseq INT(11),
leg_route TEXT,
leg_tag CHAR(64),
leg_contact CHAR(128),
leg_sockinfo CHAR(128),
CONSTRAINT b2b_entities_idx UNIQUE (type, tag0, tag1, callid)
) ENGINE=InnoDB;
CREATE INDEX b2b_entities_param ON b2b_entities (param);
INSERT INTO version (table_name, table_version) values ('b2b_logic','3');
CREATE TABLE b2b_logic (
id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
si_key CHAR(64) NOT NULL,
scenario CHAR(64),
sstate INT(2) NOT NULL,
next_sstate INT(2) NOT NULL,
sparam0 CHAR(64),
sparam1 CHAR(64),
sparam2 CHAR(64),
sparam3 CHAR(64),
sparam4 CHAR(64),
sdp TEXT(64),
lifetime INT(10) DEFAULT 0 NOT NULL,
e1_type INT(2) NOT NULL,
e1_sid CHAR(64),
e1_from CHAR(128) NOT NULL,
e1_to CHAR(128) NOT NULL,
e1_key CHAR(64) NOT NULL,
e2_type INT(2) NOT NULL,
e2_sid CHAR(64),
e2_from CHAR(128) NOT NULL,
e2_to CHAR(128) NOT NULL,
e2_key CHAR(64) NOT NULL,
e3_type INT(2),
e3_sid CHAR(64),
e3_from CHAR(128),
e3_to CHAR(128),
e3_key CHAR(64),
CONSTRAINT b2b_logic_idx UNIQUE (si_key)
) ENGINE=InnoDB;
|