Module: kamailio Branch: master Commit: ea7c58fd9bf159ca95438c2e25cb64fb63b7c6f6 URL: https://github.com/kamailio/kamailio/commit/ea7c58fd9bf159ca95438c2e25cb64f… Author: Richard Good <richard.good(a)smilecoms.com> Committer: Richard Good <richard.good(a)smilecoms.com> Date: 2015-02-03T19:18:40+02:00 modules/ims_charging: added sql script to create ims_charging tables --- Added: utils/kamctl/mysql/ims_charging_create.sql --- Diff: https://github.com/kamailio/kamailio/commit/ea7c58fd9bf159ca95438c2e25cb64f… Patch: https://github.com/kamailio/kamailio/commit/ea7c58fd9bf159ca95438c2e25cb64f… --- diff --git a/utils/kamctl/mysql/ims_charging_create.sql b/utils/kamctl/mysql/ims_charging_create.sql new file mode 100644 index 0000000..d5e0e52 --- /dev/null +++ b/utils/kamctl/mysql/ims_charging_create.sql @@ -0,0 +1,24 @@ +INSERT INTO version (table_name, table_version) values ('ro_session','6'); +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, + PRIMARY KEY (`id`), + KEY `hash_idx` (`hash_entry`,`hash_id`) +); +