/usr/share/doc/freeradius/examples/billing/clarent_db_schema-postgres.sql is in freeradius 2.1.12+dfsg-1.2.
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 | /*
* Id: postgresql.conf,v 1.8.2.11 2003/07/15 11:15:43 pnixon Exp $
*
* --- Peter Nixon [ codemonkey@peternixon.net ]
* This is a custom SQL schema for doing Clarent VoIP accounting
* Clarents don't support RADIUS but I use this along with the other
* files in this directory to do billing so it can live here :-)
*
*/
CREATE TABLE billing_record (
Id BIGSERIAL PRIMARY KEY,
local_SetupTime timestamp,
start_time NUMERIC(11),
duration INTEGER,
service_code CHAR(1),
phone_number VARCHAR(24),
ip_addr_ingress INET,
ip_addr_egress INET,
bill_type CHAR(1),
disconnect_reason CHAR(2),
extended_reason_code CHAR(2),
dialed_number VARCHAR(30),
port_number INTEGER,
codec VARCHAR(20),
h323ConfID VARCHAR(64)
);
create UNIQUE index combo on billing_record (start_time, ip_addr_ingress, h323ConfID);
|