2 * --- Peter Nixon [ codemonkey@peternixon.net ]
6 CREATE TABLE billing_record (
7 Id BIGSERIAL PRIMARY KEY,
8 local_SetupTime timestamp,
9 start_time NUMERIC(11),
12 phone_number VARCHAR(24),
16 disconnect_reason CHAR(2),
17 extended_reason_code CHAR(2),
18 dialed_number VARCHAR(30),
20 h323ConfID VARCHAR(64)
22 create UNIQUE index combo on billing_record (start_time, ip_addr_ingress, h323ConfID);