/usr/share/opensips/sqlite/b2b-create.sql is in opensips-sqlite-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 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 INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
type INTEGER NOT NULL,
state INTEGER 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 INTEGER NOT NULL,
cseq1 INTEGER,
contact0 CHAR(128) NOT NULL,
contact1 CHAR(128),
route0 TEXT,
route1 TEXT,
sockinfo_srv CHAR(64),
param CHAR(128) NOT NULL,
lm INTEGER NOT NULL,
lrc INTEGER,
lic INTEGER,
leg_cseq INTEGER,
leg_route TEXT,
leg_tag CHAR(64),
leg_contact CHAR(128),
leg_sockinfo CHAR(128),
CONSTRAINT b2b_entities_b2b_entities_idx UNIQUE (type, tag0, tag1, callid)
);
CREATE INDEX ORA_b2b_entities_param ON b2b_entities (param);
INSERT INTO version (table_name, table_version) values ('b2b_logic','3');
CREATE TABLE b2b_logic (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
si_key CHAR(64) NOT NULL,
scenario CHAR(64),
sstate INTEGER NOT NULL,
next_sstate INTEGER NOT NULL,
sparam0 CHAR(64),
sparam1 CHAR(64),
sparam2 CHAR(64),
sparam3 CHAR(64),
sparam4 CHAR(64),
sdp TEXT(64),
lifetime INTEGER DEFAULT 0 NOT NULL,
e1_type INTEGER 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 INTEGER 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 INTEGER,
e3_sid CHAR(64),
e3_from CHAR(128),
e3_to CHAR(128),
e3_key CHAR(64),
CONSTRAINT b2b_logic_b2b_logic_idx UNIQUE (si_key)
);
|