/usr/share/kamailio/xhttp_pi/acc-table is in kamailio-xml-modules 5.1.2-1ubuntu2.
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 | <!-- Declaration of acc table-->
<db_table id="acc">
<table_name>acc</table_name>
<db_url_id>mysql</db_url_id>
<column><field>id</field><type>DB1_INT</type></column>
<column><field>method</field><type>DB1_STR</type></column>
<column><field>from_tag</field><type>DB1_STR</type></column>
<column><field>to_tag</field><type>DB1_STR</type></column>
<column><field>callid</field><type>DB1_STR</type></column>
<column><field>sip_code</field><type>DB1_STR</type></column>
<column><field>sip_reason</field><type>DB1_STR</type></column>
<column><field>time</field><type>DB1_DATETIME</type></column>
</db_table>
<!-- Declaration of acc_cdrs table-->
<db_table id="acc_cdrs">
<table_name>acc_cdrs</table_name>
<db_url_id>mysql</db_url_id>
<column><field>id</field><type>DB1_INT</type></column>
<column><field>start_time</field><type>DB1_DATETIME</type></column>
<column><field>end_time</field><type>DB1_DATETIME</type></column>
<column><field>duration</field><type>DB1_DOUBLE</type></column>
</db_table>
<!-- Declaration of missed_calls table-->
<db_table id="missed_calls">
<table_name>missed_calls</table_name>
<db_url_id>mysql</db_url_id>
<column><field>id</field><type>DB1_INT</type></column>
<column><field>method</field><type>DB1_STR</type></column>
<column><field>from_tag</field><type>DB1_STR</type></column>
<column><field>to_tag</field><type>DB1_STR</type></column>
<column><field>callid</field><type>DB1_STR</type></column>
<column><field>sip_code</field><type>DB1_STR</type></column>
<column><field>sip_reason</field><type>DB1_STR</type></column>
<column><field>time</field><type>DB1_DATETIME</type></column>
</db_table>
|