[sr-dev] git:master:ea7c58fd: modules/ims_charging: added sql script to create ims_charging tables

[Richard Good]

Module: kamailio
Branch: master
Commit: ea7c58fd9bf159ca95438c2e25cb64fb63b7c6f6
URL: https://github.com/kamailio/kamailio/commit/ea7c58fd9bf159ca95438c2e25cb64fb63b7c6f6

Author: Richard Good <richard.good at smilecoms.com>
Committer: Richard Good <richard.good at 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/ea7c58fd9bf159ca95438c2e25cb64fb63b7c6f6.diff
Patch: https://github.com/kamailio/kamailio/commit/ea7c58fd9bf159ca95438c2e25cb64fb63b7c6f6.patch

---

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`)
+);
+