kamailio/utils/kamctl/mysql/ims_charging-create.sql

INSERT INTO version (table_name, table_version) values ('ro_session','3');
CREATE TABLE `ro_session` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `hash_entry` int(10) unsigned NOT NULL,
  `hash_id` int(10) unsigned NOT NULL,
  `session_id` varchar(100) NOT NULL,
  `dlg_hash_entry` int(10) unsigned NOT NULL,
  `dlg_hash_id` int(10) unsigned NOT NULL,
  `direction` int(1) unsigned NOT NULL,
  `asserted_identity` varchar(100) NOT NULL,
  `callee` varchar(100) NOT NULL,
  `start_time` datetime DEFAULT NULL,
  `last_event_timestamp` datetime DEFAULT NULL,
  `reserved_secs` int(10) DEFAULT NULL,
  `valid_for` int(10) DEFAULT NULL,
  `state` int(1) DEFAULT NULL,
  `incoming_trunk_id` varchar(20) DEFAULT NULL,
  `outgoing_trunk_id` varchar(20) DEFAULT NULL,
  `rating_group` int(11) DEFAULT NULL,
  `service_identifier` int(11) DEFAULT NULL,
  `auth_app_id` int(11) NOT NULL,
  `auth_session_type` int(11) NOT NULL,
  `pani` varchar(100) DEFAULT NULL,
  `mac` varchar(17) DEFAULT NULL,
  `app_provided_party` varchar(100) DEFAULT NULL,
  `is_final_allocation` int(1) unsigned NOT NULL,
  `origin_host` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `hash_idx` (`hash_entry`,`hash_id`)
);