multiSwitch – user manual
© TOPEX 2008 51
The My SQL data base structure is presented below:
CREATE TABLE billing(
id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (id),
tip CHAR(3),
port_src SMALLINT,
identity VARCHAR(32),
number VARCHAR(32),
date date,
time time,
duration INT,
units SMALLINT,
SIM CHAR(2),
port_dest SMALLINT,
`release` VARCHAR(15),
rel_Q850 SMALLINT,
CIMI VARCHAR(30),
selection SMALLINT,
GSM_cell VARCHAR(10),
direction VARCHAR(20),
IP_s VARCHAR(20),
PORT_s INT,
IP_RTP_s VARCHAR(20),
PORT_RTP_s INT,
IP_d VARCHAR(20),
PORT_d VARCHAR(20),
IP_RTP_d VARCHAR(20),
PORT_RTP_d INT,
session_id VARCHAR(20),
jitter INT,
packet_loss INT,
client_id INT,
direction_out VARCHAR(20),
proto_in VARCHAR(20),
proto_out VARCHAR(20),
codec VARCHAR(10),
ptime INT,
out_clientid INT,
gw_name VARCHAR(30),
id_out VARCHAR(32),
nr_out VARCHAR(32),
orig_ani VARCHAR(32),
con_dnis VARCHAR(32),
in_billing_profileid INT,
out_billing_profileid INT,
price_in FLOAT(9,2),
currency_in VARCHAR(10);
call_type VARCHAR(32);
);
The alteration of data base after an update is made like in the example below:
ALTER TABLE billing_2007_07 ADD COLUMN orig_ani VARCHAR(32);
ALTER TABLE billing_2007_07 ADD COLUMN con_dnis VARCHAR(32);
Note:
The parameter “billing_2007_07” is the billing table from month 07 year 2007.