mirror of
https://github.com/cgrates/cgrates.git
synced 2026-02-11 18:16:24 +05:00
53 lines
1.4 KiB
SQL
53 lines
1.4 KiB
SQL
--
|
|
-- Table structure for table `cdrs`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS cdrs;
|
|
CREATE TABLE cdrs (
|
|
id int(11) NOT NULL AUTO_INCREMENT,
|
|
cgrid varchar(40) NOT NULL,
|
|
run_id varchar(64) NOT NULL,
|
|
origin_host varchar(64) NOT NULL,
|
|
source varchar(64) NOT NULL,
|
|
origin_id varchar(128) NOT NULL,
|
|
tor varchar(16) NOT NULL,
|
|
request_type varchar(24) NOT NULL,
|
|
tenant varchar(64) NOT NULL,
|
|
category varchar(64) NOT NULL,
|
|
account varchar(128) NOT NULL,
|
|
subject varchar(128) NOT NULL,
|
|
destination varchar(128) NOT NULL,
|
|
setup_time datetime NOT NULL,
|
|
answer_time datetime NULL,
|
|
`usage` BIGINT NOT NULL,
|
|
extra_fields text NOT NULL,
|
|
cost_source varchar(64) NOT NULL,
|
|
cost DECIMAL(20,4) NOT NULL,
|
|
cost_details MEDIUMTEXT,
|
|
extra_info text,
|
|
created_at TIMESTAMP NULL,
|
|
updated_at TIMESTAMP NULL,
|
|
deleted_at TIMESTAMP NULL,
|
|
PRIMARY KEY (id),
|
|
UNIQUE KEY cdrrun (cgrid, run_id)
|
|
);
|
|
|
|
DROP TABLE IF EXISTS session_costs;
|
|
CREATE TABLE session_costs (
|
|
id int(11) NOT NULL AUTO_INCREMENT,
|
|
cgrid varchar(40) NOT NULL,
|
|
run_id varchar(64) NOT NULL,
|
|
origin_host varchar(64) NOT NULL,
|
|
origin_id varchar(128) NOT NULL,
|
|
cost_source varchar(64) NOT NULL,
|
|
`usage` BIGINT NOT NULL,
|
|
cost_details MEDIUMTEXT,
|
|
created_at TIMESTAMP NULL,
|
|
deleted_at TIMESTAMP NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY costid (cgrid, run_id),
|
|
KEY origin_idx (origin_host, origin_id),
|
|
KEY run_origin_idx (run_id, origin_id),
|
|
KEY deleted_at_idx (deleted_at)
|
|
);
|