This file is indexed.

/usr/share/opensips/postgres/b2b_sca-create.sql is in opensips-postgres-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
INSERT INTO version (table_name, table_version) values ('b2b_sca','1');
CREATE TABLE b2b_sca (
    id SERIAL PRIMARY KEY NOT NULL,
    shared_line VARCHAR(64) NOT NULL,
    watchers VARCHAR(255) NOT NULL,
    app1_shared_entity INTEGER DEFAULT NULL,
    app1_call_state INTEGER DEFAULT NULL,
    app1_call_info_uri VARCHAR(128) DEFAULT NULL,
    app1_call_info_appearance_uri VARCHAR(128) DEFAULT NULL,
    app1_b2bl_key VARCHAR(64) DEFAULT NULL,
    app2_shared_entity INTEGER DEFAULT NULL,
    app2_call_state INTEGER DEFAULT NULL,
    app2_call_info_uri VARCHAR(128) DEFAULT NULL,
    app2_call_info_appearance_uri VARCHAR(128) DEFAULT NULL,
    app2_b2bl_key VARCHAR(64) DEFAULT NULL,
    app3_shared_entity INTEGER DEFAULT NULL,
    app3_call_state INTEGER DEFAULT NULL,
    app3_call_info_uri VARCHAR(128) DEFAULT NULL,
    app3_call_info_appearance_uri VARCHAR(128) DEFAULT NULL,
    app3_b2bl_key VARCHAR(64) DEFAULT NULL,
    app4_shared_entity INTEGER DEFAULT NULL,
    app4_call_state INTEGER DEFAULT NULL,
    app4_call_info_uri VARCHAR(128) DEFAULT NULL,
    app4_call_info_appearance_uri VARCHAR(128) DEFAULT NULL,
    app4_b2bl_key VARCHAR(64) DEFAULT NULL,
    app5_shared_entity INTEGER DEFAULT NULL,
    app5_call_state INTEGER DEFAULT NULL,
    app5_call_info_uri VARCHAR(128) DEFAULT NULL,
    app5_call_info_appearance_uri VARCHAR(128) DEFAULT NULL,
    app5_b2bl_key VARCHAR(64) DEFAULT NULL,
    app6_shared_entity INTEGER DEFAULT NULL,
    app6_call_state INTEGER DEFAULT NULL,
    app6_call_info_uri VARCHAR(128) DEFAULT NULL,
    app6_call_info_appearance_uri VARCHAR(128) DEFAULT NULL,
    app6_b2bl_key VARCHAR(64) DEFAULT NULL,
    app7_shared_entity INTEGER DEFAULT NULL,
    app7_call_state INTEGER DEFAULT NULL,
    app7_call_info_uri VARCHAR(128) DEFAULT NULL,
    app7_call_info_appearance_uri VARCHAR(128) DEFAULT NULL,
    app7_b2bl_key VARCHAR(64) DEFAULT NULL,
    app8_shared_entity INTEGER DEFAULT NULL,
    app8_call_state INTEGER DEFAULT NULL,
    app8_call_info_uri VARCHAR(128) DEFAULT NULL,
    app8_call_info_appearance_uri VARCHAR(128) DEFAULT NULL,
    app8_b2bl_key VARCHAR(64) DEFAULT NULL,
    app9_shared_entity INTEGER DEFAULT NULL,
    app9_call_state INTEGER DEFAULT NULL,
    app9_call_info_uri VARCHAR(128) DEFAULT NULL,
    app9_call_info_appearance_uri VARCHAR(128) DEFAULT NULL,
    app9_b2bl_key VARCHAR(64) DEFAULT NULL,
    app10_shared_entity INTEGER DEFAULT NULL,
    app10_call_state INTEGER DEFAULT NULL,
    app10_call_info_uri VARCHAR(128) DEFAULT NULL,
    app10_call_info_appearance_uri VARCHAR(128) DEFAULT NULL,
    app10_b2bl_key VARCHAR(64) DEFAULT NULL,
    CONSTRAINT b2b_sca_sca_idx UNIQUE (shared_line)
);

ALTER SEQUENCE b2b_sca_id_seq MAXVALUE 2147483647 CYCLE;