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

Module: kamailio Branch: master Commit: 287884ba9183da3eed2eb4fba1e31d287730fe26 URL: https://github.com/kamailio/kamailio/commit/287884ba9183da3eed2eb4fba1e31d2… Author: mikomarrache &lt;mikomarrache(a)users.noreply.github.com&gt; Committer: mikomarrache &lt;mikomarrache(a)users.noreply.github.com&gt; 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/287884ba9183da3eed2eb4fba1e31d2… Patch: https://github.com/kamailio/kamailio/commit/287884ba9183da3eed2eb4fba1e31d2… --- 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>