Module: kamailio Branch: master Commit: 287884ba9183da3eed2eb4fba1e31d287730fe26 URL: https://github.com/kamailio/kamailio/commit/287884ba9183da3eed2eb4fba1e31d28...
Author: mikomarrache mikomarrache@users.noreply.github.com Committer: mikomarrache mikomarrache@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/287884ba9183da3eed2eb4fba1e31d28... Patch: https://github.com/kamailio/kamailio/commit/287884ba9183da3eed2eb4fba1e31d28...
---
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:paraThis 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>