[sr-dev] git:master:287884ba: acc: update schema and version

[mikomarrache]

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

Author: mikomarrache <mikomarrache at users.noreply.github.com>
Committer: mikomarrache <mikomarrache at users.noreply.github.com>
Date: 2015-04-14T20:37:37+03:00

acc: update schema and version


Change type of columns:
  -> start_time and end_time as datetime
  -> duration as float
Also increment version of acc_cdrs table.

---

Modified: lib/srdb1/schema/acc_cdrs.xml

---

Diff:  https://github.com/kamailio/kamailio/commit/287884ba9183da3eed2eb4fba1e31d287730fe26.diff
Patch: https://github.com/kamailio/kamailio/commit/287884ba9183da3eed2eb4fba1e31d287730fe26.patch

---

diff --git a/lib/srdb1/schema/acc_cdrs.xml b/lib/srdb1/schema/acc_cdrs.xml
index 22cba14..84bb678 100644
--- a/lib/srdb1/schema/acc_cdrs.xml
+++ b/lib/srdb1/schema/acc_cdrs.xml
@@ -9,7 +9,7 @@
 
 <table id="acc_cdrs" xmlns:db="http://docbook.org/ns/docbook">
     <name>acc_cdrs</name>
-    <version>1</version>
+    <version>2</version>
     <type db="mysql">&MYSQL_TABLE_TYPE;</type>
     <description>
         <db:para>This table is used by the ACC module to report on CDRs relying on dialog callbacks. More information is available at: &KAMAILIO_MOD_DOC;acc.html
@@ -28,24 +28,22 @@
 
 	<column id="start_time">
         <name>start_time</name>
-        <type>string</type>
-        <size>32</size>
-        <description>Start time</description>
+        <type>datetime</type>
+        <description>Start date and time</description>
         <default/>
     </column>
 
     <column>
         <name>end_time</name>
-        <type>string</type>
-        <size>32</size>
-        <description>End time</description>
+        <type>datetime</type>
+        <description>End date and time</description>
         <default/>
     </column>
 
     <column>
         <name>duration</name>
-        <type>string</type>
-        <size>32</size>
+        <type>float</type>
+        <size>10,3</size>
         <description>Duration</description>
         <default/>
     </column>